Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Introduction to PostgreSQL Connector
  3. Connections for PostgreSQL
  4. Mappings and mapping tasks with PostgreSQL Connector
  5. PostgreSQL objects in mapping tasks
  6. Lookup transformation
  7. SQL transformation
  8. Migrating a mapping
  9. PostgreSQL SQL ELT optimization
  10. Data type reference
  11. Troubleshooting

PostgreSQL Connector

PostgreSQL Connector

PostgreSQL mapping doesn't display the related objects

PostgreSQL mapping doesn't display the related objects

When you configure multiple objects as the source type in a mapping and select objects that have a primary key and foreign key relationship using the
Add Related Objects
option, the related objects are not displayed.
This issue occurs when you connect to a PostgreSQL database version 15.x or 16.x using the PostgreSQL connection and the JDBC driver from either the
base
or
rollback
folder.
To fix this issue, configure the JDBC driver from the
latest
folder for the PostgreSQL connection.
For more information about configuring the latest JDBC driver, see Configure the JDBC driver for PostgreSQL Connector Knowledge article.

0 COMMENTS

We’d like to hear from you!