Re: [JDBC] [BUGS] JDBC getImortedKeys() getExportedKeys()

#1

Patch Applied,

Thanks,

Dave
On Mon, 2003-11-03 at 05:25, Kris Jurka wrote:

Quote:

On Fri, 15 Aug 2003, Richard Froud wrote:

Please enter a FULL description of your problem:
------------------------------------------------
When reading database metadata for foreign keys using the JDBC
DatabaseMetaData.getImportedKeys() and DatabaseMetaData.getExportedKeys()
methods the ON UPDATE rule is returned as the ON DELETE rule. It is also
correctly returned as the ON UPDATE rule. Therefore there is no way to
access the ON DELETE rule. Consequenntly innaccurate representations of the
database structure are obtained.

Here is a patch for this. Additionally the on delete rule would not
return importedKeyRestrict because of a missing if statement. Also an
addition to the test suite is attached.

Kris Jurka

__________________________________________________ ____________________

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [JDBC] [BUGS] JDBC getImortedKeys() getExportedKeys()

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [JDBC] [BUGS] JDBC getImortedKeys() getExportedKeys() - 11-03-2003 , 11:23 AM