Re: Can't get all Imported Keys from dmd

The development driver for the jdbc? Or the odbc driver in the
postgresql release?

Thanks!

On Tue, 2002-06-25 at 10:22, Dave Cramer wrote:
> 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
> >
> >
> >
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
--
David A. Bartmess
Software Configuration Manager / Sr. Software Developer
eDingo Enterprises
http://edingo.net