Re: [JDBC] JDBC getImortedKeys() getExportedKeys()

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Richard Froud <rfroud(at)ntlworld(dot)com>, pgsql-bugs(at)postgresql(dot)org, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] JDBC getImortedKeys() getExportedKeys()
Date: 2003-11-03 15:24:39
Message-ID: 1067873079.1622.69.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc

Patch Applied,

Thanks,

Dave
On Mon, 2003-11-03 at 05:25, Kris Jurka wrote:
> On Fri, 15 Aug 2003, Richard Froud wrote:
>
> > Please enter a FULL description of your problem:
> > ------------------------------------------------
> > When reading database metadata for foreign keys using the JDBC
> > DatabaseMetaData.getImportedKeys() and DatabaseMetaData.getExportedKeys()
> > methods the ON UPDATE rule is returned as the ON DELETE rule. It is also
> > correctly returned as the ON UPDATE rule. Therefore there is no way to
> > access the ON DELETE rule. Consequenntly innaccurate representations of the
> > database structure are obtained.
>
> Here is a patch for this. Additionally the on delete rule would not
> return importedKeyRestrict because of a missing if statement. Also an
> addition to the test suite is attached.
>
> Kris Jurka
>
>
> ______________________________________________________________________
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Cramer 2003-11-03 15:28:46 Re: [JDBC] Bug #886: jdbc "update row" can mess up other
Previous Message Tom Lane 2003-11-03 15:10:40 Re: Repeatedly breaking indexes

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-11-03 15:28:46 Re: [JDBC] Bug #886: jdbc "update row" can mess up other
Previous Message Dave Cramer 2003-11-03 15:24:12 Re: Driver.acceptsURL(String) not working correctly