From: | "Richard Froud" <rfroud(at)ntlworld(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | JDBC getImortedKeys() getExportedKeys() incorrect ON DELETE property |
Date: | 2003-08-15 09:10:45 |
Message-ID: | GHEFKFIOHBAJDNLDFBEKCEJBCAAA.rfroud@ntlworld.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-jdbc |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Richard Froud
Your email address : richard(at)hospitalityis(dot)co(dot)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(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-15 11:23:55 | Re: two minor issues with date time types |
Previous Message | Stephan Szabo | 2003-08-15 02:47:44 | Re: two minor issues with date time types |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2003-08-15 12:17:45 | CVS JDBC driver will try to use server-side-prepare on unpreparable SQL |
Previous Message | Robert Maye | 2003-08-15 08:04:13 | Re: jdbc driver for jbuilder |