Multi column foreign keys.

From: Mofeed Shahin <mofeed(dot)shahin(at)dsto(dot)defence(dot)gov(dot)au>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Multi column foreign keys.
Date: 2003-12-09 04:06:32
Message-ID: 200312091436.32439.mofeed.shahin@dsto.defence.gov.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello all,

I've got the following tables :

CREATE TABLE Student
(
Student_ID serial PRIMARY KEY,
First_Name varchar(50),
Last_Name varchar(50),
UNIQUE (First_Name, Last_Name)
);

CREATE TABLE Address
(
First_Name varchar(50),
Last_Name varchar(50),
Address varchar(50),
PRIMARY KEY (First_Name, Last_Name),
FOREIGN KEY (First_Name, Last_Name) REFERENCES student (First_Name,Last_Name)
);

And some code like :

Driver driver = (Driver)Class.forName("org.postgresql.Driver").newInstance();
DriverManager.registerDriver(driver);
String url = "jdbc:postgresql:test";
Connection con = DriverManager.getConnection(url, "mof", "");
DatabaseMetaData meta = con.getMetaData ();
ResultSet metaRS = meta.getImportedKeys(null, null, "address");

while (metaRS.next())
System.out.println("FK_C == " + metaRS.getString("FKCOLUMN_NAME"));

Which only gives me :

FK_C == first_name

How am I supposed to find out about "Last_Name" ?

Mof.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message TANIDA Yutaka 2003-12-09 04:15:42 Re: CMP Bean problem
Previous Message Kris Jurka 2003-12-09 02:46:48 Re: CMP Bean problem