Re: [BUGS] No dependency between fkey constraint and unique index

2002-09-21 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > I do agree that a dependency entry from the foreign key constraint to > the unique or primary key constraint would be useful. That information > isn't immediately available, as the initial check is performed early on > in the parser. The constraint creati

[BUGS] No dependency between fkey constraint and unique index

2002-09-12 Thread Kris Jurka
The following statements will fail... CREATE TABLE t1 (a int); CREATE TABLE t2 (a int references t1(a)); ERROR: UNIQUE constraint matching given keys for referenced table "t1" not found But I can do the following... CREATE TABLE t3 (a int primary key); CREATE TABLE t4 (a int references t3(a));