Re: getExportedKeys/getImportedKeys

MeddelandeHi.
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(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Patrik Lundgren
Sent: 12 March 2003 01:41 PM
To: pgsql-jdbc(at)postgresql(dot)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