Thread: Getting foreign keys seems buggy

Getting foreign keys seems buggy

From
Amar Sagoo
Date:
Hi,

I'm trying to get a list of foreign keys for a table in a PostgreSQL
database through the JDBC interface.
However, the DatabaseMetaData.getImportedKeys() method only returns one of
the foreign keys, although the table references more than one other table.
I also noticed that instead of listing each field of the foreign key in a
separate row of the result set, it puts them together in one row, separated by
commas.

Is this a known bug in the JDBC driver?

Cheers

Amar

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net


Re: Getting foreign keys seems buggy

From
"Dave Cramer"
Date:
Amar,

I think this has been fixed in the current sources. The driver on the
site isn't up to date however

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Amar Sagoo
Sent: Monday, March 11, 2002 3:07 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Getting foreign keys seems buggy


Hi,

I'm trying to get a list of foreign keys for a table in a PostgreSQL
database through the JDBC interface. However, the
DatabaseMetaData.getImportedKeys() method only returns one of the
foreign keys, although the table references more than one other table. I
also noticed that instead of listing each field of the foreign key in a
separate row of the result set, it puts them together in one row,
separated by commas.

Is this a known bug in the JDBC driver?

Cheers

Amar

--
GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)