Ð ÐÑÑ, 17.08.2004, Ð 16:46, Tom Lane ÐÐÑÐÑ:

> I think one reason for this is that otherwise it's not clear which
> unique constraint the FK constraint depends on.  Consider
> 
>       create table a (f1 int unique, f2 int unique);
> 
>       create table b (f1 int, f2 int,
>                       foreign key (f1,f2) references a(f1,f2));
> 
> How would you decide which constraint to make the FK depend on?

Either way, the semantics are the same, right?

-- 
Markus Bertheau <[EMAIL PROTECTED]>


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to