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