Postgres Pro
Downloads
Home   >   mailing lists

Re: FOREIGN KEY composite_type.its_field REFERENCES .... - Mailing list pgsql-general

From Tom Lane
Subject Re: FOREIGN KEY composite_type.its_field REFERENCES ....
Date
Msg-id 24354.1266946574@sss.pgh.pa.us
Whole thread Raw
In response to FOREIGN KEY composite_type.its_field REFERENCES ....  (Belka Lambda <lambda-belka@yandex.ru>)
List pgsql-general
Tree view 
Belka Lambda <lambda-belka@yandex.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

pgsql-general by date:

Previous
From: dipti shah
Date:
Subject: Re: SET Role doesn't work from Security Definer Function...
Next
From: Tom Lane
Date:
Subject: Re: "make check" failed on 8.4.2 install