| 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: | Whole Thread | Raw Message | 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 |