Re: getExportedKeys/getImportedKeys

Patrik

Can you send me a small sql file with some exported keys to test this. I
have a 7.2 version somewhere.

Dave
On Wed, 2003-03-12 at 09:22, Patrik Lundgren wrote:
> Well, that is one ting we can rule out. I've made sure that the table
> name is correct. I've tested lower case, upper case and everything in
> between. Does anyone have any experience with using this function with
> 7.2? Again my problem is that getExportedKeys/getImportedKeys returns
> an empty ResultSet.
>
> Regards,
> Patrik Lundgren
> -----Ursprungligt meddelande-----
> Från: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] För Carl Olivier
> Skickat: Wednesday, March 12, 2003 1:13 PM
> Till: Patrik Lundgren; pgsql-jdbc@postgresql.org
> Ämne: Re: [JDBC] getExportedKeys/getImportedKeys
>
>
>         Hi.
>         PostGreSql is CASE SESITIVE - for creating foreign keys etc.
>         This seems to hold true for meta data retrieval etc (I admit
>         to having somne trouble with this).
>
>         So, if you are passing the table pattern through - ensure that
>         it is LOWER CASE ( *I think* ).
>
>         One other thing that I found funny with the JDBC
>         implementation is this.
>
>         Data Type TEXT - when you get the meta data back for a column
>         of type TEXT, the data type int (as specified in
>         java.sql.Types.LONGVARCHAR) - wich is what TEXT is - return 12
>         - this si incorrect according to java.sql.Types - it should be
>         returning -1, as 12 is the VARCHAR java.sql.Types datatype id.
>
>         I am using version 7.3, not 7.2 so not sure if this was a bug
>         back and has been fixed...
>
>         Best regards,
>
>         Carl
>                 -----Original Message-----
>                 From: pgsql-jdbc-owner@postgresql.org
>                 [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of
>                 Patrik Lundgren
>                 Sent: 12 March 2003 01:41 PM
>                 To: pgsql-jdbc@postgresql.org
>                 Subject: [JDBC] getExportedKeys/getImportedKeys
>
>
>                 I'm having real problems with getting the foreign keys
>                 from my db. In fact I'm not getting it to work at all.
>                 I'm running postgresql 7.2 and I noticed that the code
>                 for getting the keys is different for 7.2 and 7.3 in
>                 AbstractJdbc1DatabaseMetaData.java. I've tested all
>                 different parameters I can think of but still not
>                 getting any results. I've made sure that the table
>                 parameter is correct and passed null for catalog and
>                 schema. Is the method not working or what can I be
>                 doing wrong?
>
>                 Desperate... Thanks in advance for any help! Btw I'm
>                 making a database admin tool for multiple databases so
>                 I really need this to work or my diagrams won't look
>                 so good.
>
>                 Regards,
>                 Patrik Lundgren
--
Dave Cramer <Dave@micro-automation.net>