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
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));