Re: Can't get all Imported Keys from dmd - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Can't get all Imported Keys from dmd
Date
Msg-id 1025022162.2102.124.camel@inspiron.cramers
Whole thread Raw
In response to Can't get all Imported Keys from dmd  ("David A. Bartmess" <dingodave@edingo.net>)
Responses Re: Can't get all Imported Keys from dmd
List pgsql-jdbc
David,

Try the development driver, this has been fixed in the latest sources

Dave
On Tue, 2002-06-25 at 12:15, David A. Bartmess wrote:
> The following code SHOULD (according to the JDK1.4 docs) get all the
> primary keys related to a table's foreign keys, if I read the docs
> right. But I get back a ResultSet only containing one (1) key, not two,
> as in my table.
>
> Can someone explain this to me? Why won't it return all the keys in the
> ResultSet?
>
> Thanks!
>
> ResultSet fkpk = dmd.getImportedKeys("", "", "login");
>
> while (fkpk.next())
> {
>     System.out.println("PK: " + fkpk.getString("PKTABLE_NAME"));
>     System.out.println("\t" + fkpk.getString("PKCOLUMN_NAME"));
>     System.out.println("FK: " + fkpk.getString("FKTABLE_NAME"));
>     System.out.println("\t" + fkpk.getString("FKCOLUMN_NAME"));
> }
>
> System.out.println(" ");
> **********************************
> Table creation script:
>
> drop table login;
> drop sequence login_id_seq;
>
> create table login(
>     id            serial primary key,
>     memberid        int references members(id),
>     userid            varchar(15) not null,
>     password        varchar(15) not null,
>     verification        char(20),
>     verifydatesent        date,
>     verifydaterecd        date,
>     accesslevel        int references accesslevels(id),
>     remoteip        varchar(16),
>     reminderquestion    varchar(80),
>     reminderanswer        varchar(25)
> );
> create index idxloginid on login(id);
> create index idxlogin_memberid on members(id);
>
>
> **********************************
> Test results:
>
> PK: accesslevels
>         id
> FK: login
>         accesslevel
>
>
>
> --
> David A. Bartmess
> Software Configuration Manager / Sr. Software Developer
> eDingo Enterprises
> http://edingo.net
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
>






pgsql-jdbc by date:

Previous
From: "David A. Bartmess"
Date:
Subject: Can't get all Imported Keys from dmd
Next
From: Barry Lind
Date:
Subject: Re: [HACKERS] Definite bug in JDBC