Re: getExportedKeys/getImportedKeys more information - Mailing list pgsql-jdbc

Ok, read the spec, a primary key is required here, so this is why this
doesn't work.
On Wed, 2003-03-12 at 20:03, Dave Cramer wrote:
> Ok,
>
> This doesn't work on a 7.3 db either :(
>
> The think is that serial does not create a primary key ( news to me too
> )
>
> so if you just change your sql to be
>
> create table foo ( id serial primary key .... ) it will work
>
> but obviously this is not desirable
>
> I will look some more when I have more time, this should get you going
> for now though
>
> Dave
> On Wed, 2003-03-12 at 15:07, Patrik Lundgren wrote:
> > Sounds great, thanks a lot.
> >
> > /Patrik
> >
> > -----Ursprungligt meddelande-----
> > Från: Dave Cramer [mailto:davec@fastcrypt.com]
> > Skickat: Wednesday, March 12, 2003 7:48 PM
> > Till: Patrik Lundgren
> > Kopia: pgsql-jdbc@postgresql.org
> > Ämne: Re: [JDBC] getExportedKeys/getImportedKeys
> >
> >
> > Ok, I have confirmed that it isn't working with a 7.3 driver and a 7.2
> > db so now I'll have a crack at fixing it.
> >
> > Dave
> > On Wed, 2003-03-12 at 10:54, Patrik Lundgren wrote:
> > > I've tried using the latest stable JDBC3 driver (the one for 7.3), and
> >
> > > I also just tested the latest development build. Sadly no difference.
> > > The thing is that when looking at the CVS I see that this is handled
> > > differently in 7.3 since the system tables have changed but it's not
> > > like itäs not supported in earlier versions.
> > >
> > > I haven't had time to upgrade postgresql to 7.3 yet so I don't know if
> >
> > > I'll get the same problem there. Most likely I will not since there
> > > are not so many different parameters to call getExportedKeys with. If
> > > catalog and schema is set to null and the table name is correct then
> > > there should be no problem. Unfortunately I don't have access to any
> > > 7.3 servers so I can't test this at the moment. This is going to be a
> > > smaller and smaller problem if it works with 7.3 since people are
> > > starting to upgrade. It would be nice though if it worked with 7.2.
> > >
> > > Thanks everyone who answered so far.
> > >
> > > Regards,
> > > Patrik
> > >
> > > -------------------------------
> > >
> > >
> > > Patrik,
> > >
> > > Can you try Barry's suggestion before I dig into it.
> > >
> > > Dave
> > > On Wed, 2003-03-12 at 10:16, Barry Lind wrote:
> > > > Patrik,
> > > >
> > > > Another thing you mention you are using 7.2.  Are you using 7.2 for
> > > > both
> > > > the driver and the server?  If so have you tried using the 7.3
> > driver
> > > > against the 7.2 server?  This is a supported setup and the 7.3
> > driver
> > > > has a significant number of fixes in this area.
> > > >
> > > > thanks,
> > > > --Barry
> > > >
> > > >
> > > > 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
> > > >
> > > >
> > > >
> > > > ---------------------------(end of
> > > > broadcast)---------------------------
> > > > TIP 6: Have you searched our list archives?
> > > >
> > > > http://archives.postgresql.org
--
Dave Cramer <Dave@micro-automation.net>