Skip site navigation (1) Skip section navigation (2)

Re: []

From: Jason Davies <jason(at)netspade(dot)com>
To: Dave Cramer <Dave(at)micro-automation(dot)net>
Cc: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: []
Date: 2001-11-03 12:54:40
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

Here is yet another patch for DatabaseMetaData which does several things:
a) Currently an extra key is returned in both getExportedKeys() and getImportedKeys(). So a foreign key relationship, duplicate keys are returned. This has been fixed.
b) PK_NAME is now returned.
c) The whole SQL query has been optimized (no more ugly inner selects).
d) The getExportedKeys() and getImportedKeys() implementation has been put into a single getImportedExportedKeys() to save duplcating the code.
e) KEY_SEQ is now also returned.

There is however one problem to do with multiple foreign key columns. Should they be returned as a single row, separated by commas? Or returned in separate rows? By multiple foreign key columns I mean, "alter table ptable add constraint ptable_fkey foreign key (pcol1, pcol2) references ftable (fcol1, fcol2)".

I think returning separate rows is the most correct way to do it, assuming the SQL statement above is equivalent to 2 separate fkeys.

Any comments are welcome,


On Fri, Nov 02, 2001 at 07:04:16PM -0500, Dave Cramer wrote:
> Jason,
> The current sources should be patched as per your patch. I also fixed
> jdbc1 so it would compile
> Dave 
> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Jason Davies
> Sent: November 2, 2001 5:16 PM
> To: Dave Cramer
> Cc: PostgreSQL JDBC
> Subject: [JDBC] [jason(at)netspade(dot)com:]
> Sorry, I forgot to attach the file. How embarrassing :)
> -- 
> Jason Davies
> jason(at)netspade(dot)com
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Jason Davies


In response to


pgsql-jdbc by date

Next:From: Nikola MilutinovicDate: 2001-11-03 15:13:19
Subject: Encoding weirdness with JDBC, driver crashing?
Previous:From: Carlos AugustoDate: 2001-11-03 04:10:02

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group