[#1011105] SPIDatabaseMetaData.getPrimaryKeys updated to 8.1+ jdbc code

View Trackers | Patches | Download .csv | Monitor

Date:
2011-10-13 23:19
Priority:
3
State:
Open
Submitted by:
Nathan Egge (negge)
Assigned to:
Nobody (None)
Category:
Group:
Summary:
SPIDatabaseMetaData.getPrimaryKeys updated to 8.1+ jdbc code

Detailed description
The current getPrimaryKeys method appears to use an older 7.3+ style of retrieving the primary keys from the pg_catalog table. This older code does not work when the tables have been altered.

Attaching a patch to upgrade to the 8.1+ style of retrieving the meta data.

NOTE: Unlike the official JDBC driver, pl/Java does not appear to use the DB version internally to craft the different metadata queries. This may become an issue as postgresql continues to evolve and / or the inclusion of a JDBC5 spec.

Followup

No Followups Have Been Posted

Attached Files:

Attachments:
pljava-getPrimaryKeys.patch

Changes:

Field Old Value Date By
File Added692: pljava-getPrimaryKeys.patch2011-10-13 23:19negge
Powered By FusionForge