getImportedKeys returns only one key

From: Ian Wehrman <ian(at)labfire(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: getImportedKeys returns only one key
Date: 2002-06-01 18:12:47
Message-ID: 20020601131247.A13692@labfire.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hello all,
i have the following relations defined:

create table users (
UserID serial primary key,
UserName varchar(255) unique not null,
...);

create table Organizations (
OrgID serial primary key,
OrgName varchar(255) unique not null,
...);

create table UserOrgs (
OrgID int not null references organizations(orgid),
UserID int not null references users(userid),
primary key (userid,orgid)
);

and the following bit of code:

Connection cn = DriverManager.getConnection(url, user, pass);
DatabaseMetaData dbmd = cn.getMetaData();
ResultSet rs = dbmd.getImportedKeys(null, null, "userorgs");
while (rs.next()) {
out.println(rs.getString("PKTABLE_NAME"));
}

...which prints only "organizations". In other tests I've repeatedly found
that the ResultSet returned by getImportedKeys never contains more than one
row. I've tested this with the latest stable jdbc driver, the latest
development driver, and with a driver compiled from cvs. I'm currently running
postgresql-7.1.3 on the server. Can anyone give me a hint as to what i'm doing
wrong, or is this a problem with the driver?

Thanks,
Ian Wehrman

--
Labfire, Inc.
Seamless Technical Solutions
http://labfire.com/

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-06-02 13:16:15 Re: getImportedKeys returns only one key
Previous Message Noel Rappin 2002-05-31 17:08:11 Re: Issues with Array Interface