Hi,
I suppose 'detail' is the table name? And what is master?
Thanks
Huub
> create table detail
> (
> id1 integer,
> id2 integer,
> CONSTRAINT c1 PRIMARY KEY(id1,id2),
> CONSTRAINT c2 FOREIGN KEY(id1,id2) REFERENCES master
> );
>
> Do you really need such detail table? You can just add columns to master
> table.
>
> Tomasz Myrta
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html