Re: primary + foreign key

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