Re: FOREIGN KEY composite_type.its_field REFERENCES ....

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Belka Lambda <lambda-belka(at)yandex(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FOREIGN KEY composite_type.its_field REFERENCES ....
Date: 2010-02-23 17:36:14
Message-ID: 24354.1266946574@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Belka Lambda <lambda-belka(at)yandex(dot)ru> writes:
> Is there a way to construct FOREIGN KEYs from parts of composite-typed field?

No, and even if the system let you do it, the performance would probably
suck. Composite-type fields are not something to be used with abandon.
To me your example looks like a design pattern to avoid.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-02-23 17:41:39 Re: "make check" failed on 8.4.2 install
Previous Message dipti shah 2010-02-23 17:21:24 Re: SET Role doesn't work from Security Definer Function...