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
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
