Re: More on inheritance and foreign keys - Mailing list pgsql-hackers

From Zeugswetter Andreas DCP SD
Subject Re: More on inheritance and foreign keys
Date
Msg-id E1539E0ED7043848906A8FF995BDA5790116B75D@m0143.s-mxs.net
Whole thread Raw
In response to More on inheritance and foreign keys  (Albert Cervera Areny <albertca@hotpop.com>)
Responses Re: More on inheritance and foreign keys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>     The solution to the foreign key problem seems easy if I
> modify PostgreSQL implementation and take off the ONLY word
> from the SELECT query, but it's not an option for me, as I'm

I think that the ONLY was wrong from day one :-(
The default in other areas is table including childs.
(Not like in old pg where you had to use tab* to include childs)
(iirc leaving off ONLY is not sufficient because of lockingproblems)

Of course then we would needREFERENCES tenk ONLY (unique1)
to allow current behavior.

Andreas


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Connection Broken with Custom Dicts for TSearch2
Next
From: Hannu Krosing
Date:
Subject: Re: More on inheritance and foreign keys