Possible wrong Postgres query on ADDITIONAL_TABLE_ATTRIBUTES.sql

[marciomed1]

Description

The query on ADDITIONAL_TABLE_ATTRIBUTES seems to search for tables and it's schema, but the join between the tables and the schema is done by table's owner, which seems wrong.

Original join:

ON C.RELOWNER = NC.NSPOWNER

Join to fetch table's schema should be:

ON c.relnamespace = nc.oid

The way the query is written returns way more rows than expected with a hundred of schemas of the same owner.
We are comming here from another project, where this query is causing too much execution delay.
I'm not sure if the query should really return the schema of the table, or it's Obevo who's using it the wrong way.

How to Reproduce

No response

Relevant log output

No response

SchemaCrawler Version

Latest

Java Version

Latest

Operating System and Version

Any

Relational Database System and Version

Postgres

JDBC Driver and Version

Any

[sualeh]

Thanks. I will take a look.

[sualeh]

@marciomed1 - this will be fixed in the next release of SchemaCrawler. Thanks for reporting it.