Patches
Search the entire project
This project's trackers
This project's releases
Project
People
Skill
Advanced search
Log In
|
New Account
Home
My Page
Projects
Code Snippets
Project Openings
PL/Java
Summary
Activity
Tracker
Lists
Files
[#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 Added
692: pljava-getPrimaryKeys.patch
2011-10-13 23:19
negge
