JDBC getImortedKeys() getExportedKeys() incorrect ON DELETE property

============================================================================
                         POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Richard Froud
Your email address    : richard@hospitalityis.co.uk


System Configuration
---------------------
   Architecture (example: Intel Pentium) : All - Present on Linux, Windows,
Unix

   Operating System (example: Linux 2.0.26 ELF) :
            Windows, Linux and Unix

   PostgreSQL version (example: PostgreSQL-7.3.4):   7.3 all versions

   Compiler used (example:  gcc 2.95.2)        :


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.




Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Create a foreign key referencing the primary key of another table.  Use: ON
UPDATE NO ACTION, ON DELETE CASCADE.   Use JDBC
DatabaseMetaData.getImportedKeys() to read from the first table.  Both the
ON UPDATE and ON DELETE values returned are the same.




If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------





---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org