From: | Carlos Correia <carlos(at)m16e(dot)com> |
---|---|
To: | Lista Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Problems with DatabaseMetaData.getImportedKeys |
Date: | 2004-02-06 14:08:13 |
Message-ID: | 1076076492.31184.43.camel@devo.m16e.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
When I try to run the program DatabaseTest.java (see attach) with the
db-test database (see attach: db-test.sql) I get duplicated tuples for
each foreign key:
<Database.getKeyInfo> for table: table_1
>>> Imported keys
>>> Exported keys:
1: c2
from table_1 to table_2.t2_f2
1: c1
from table_1 to table_2.t2_f1
1: c2
from table_1 to table_2.t2_f2
1: c1
from table_1 to table_2.t2_f1
<Database.getKeyInfo> for table: table_2
>>> Imported keys
1: c2
from table_1 to table_2.t2_f2
1: c1
from table_1 to table_2.t2_f1
1: c2
from table_1 to table_2.t2_f2
1: c1
from table_1 to table_2.t2_f1
>>> Exported keys:
Is there any way of avoiding these duplicated tuples?
I'm running PostgreSQL version 7.3.2 (Mandrake 9.1) with pg73jdbc3.jar
driver.
Thanks,
carlos
Attachment | Content-Type | Size |
---|---|---|
DatabaseTest.java | text/x-java | 2.1 KB |
db-test.sql | text/x-sql | 490 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Correia | 2004-02-06 15:13:56 | Re: How to get a table's constraints |
Previous Message | Kris Jurka | 2004-02-06 14:07:45 | Re: Problems with DatabaseMetaData.getImportedKeys |