On Fri, 19 Mar 2004, BRINER Cedric wrote: > CREATE TABLE test (key1 int, key2 int , primary key (key1,key2), parent > <?kind of data type?> constraint parent references test );
Foreign keys must reference a unique value. If the only uniqueness constraint is (key1, key2) as above, then it requires two columns to do the constraint (one holding the referenced key1 value, one holdign the referenced key2 value) and a table level foreign key constraint or you need something like a serial key added to the table. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org