Re: [jason@netspade.com: DatabaseMetaData.java.diff]

My patch has already been applied, I believe.

--Jase.

On Fri, Feb 22, 2002 at 02:52:30PM -0500, Bruce Momjian wrote:
>
> Your patch has been added to the PostgreSQL unapplied patches list at:
>
>     http://candle.pha.pa.us/cgi-bin/pgpatches
>
> I will try to apply it within the next 48 hours.  JDBC maintainers will
> review.
>
>
> ---------------------------------------------------------------------------
>
>
> Jason Davies wrote:
>
> Checking application/pgp-signature: FAILURE
> -- Start of PGP signed section.
> > Dave,
> >
> > 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()
tosave 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,
separatedby commas? Or returned in separate rows? By multiple foreign key columns I mean, "alter table ptable add
constraintptable_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
2separate fkeys. 
> >
> > Any comments are welcome,
> >
> > Jason
> >
> > 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@postgresql.org
> > > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Jason Davies
> > > Sent: November 2, 2001 5:16 PM
> > > To: Dave Cramer
> > > Cc: PostgreSQL JDBC
> > > Subject: [JDBC] [jason@netspade.com: DatabaseMetaData.java.diff]
> > >
> > >
> > >
> > > Sorry, I forgot to attach the file. How embarrassing :)
> > >
> > > --
> > > Jason Davies
> > >
> > > jason@netspade.com
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 2: you can get off all lists at once with the unregister command
> > >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
> > --
> > Jason Davies
> >
> > jason@netspade.com
>
> [ Attachment, skipping... ]
> -- End of PGP section, PGP failed!
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

--
Jason Davies

jason@netspade.com