Problems with DatabaseMetaData.getImportedKeys

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

Responses

Browse pgsql-jdbc by date

  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