[EMAIL PROTECTED] (Neil Zanella) writes:
> CREATE TABLE X (
> A INT,
> B INT,
> PRIMARY KEY (A, B)
> );
> CREATE TABLE Y (
> A INT,
> B INT,
> C INT,
> PRIMARY KEY (C),
> FOREIGN KEY (B, A) REFERENCES X
> );
> whereas I was expecting the database server to match the names as in:
Hello,
Consider the following code run under PostgreSQL 7.3.4:
CREATE TABLE X (
A INT,
B INT,
PRIMARY KEY (A, B)
);
CREATE TABLE Y (
A INT,
B INT,
C INT,
PRIMARY KEY (C),
FOREIGN KEY (B, A) REFERENCES X
);
INSERT INTO X (A, B) VALUES (1, 2);
INSERT INTO Y (A, B, C) VALUES (1, 2,
