Re: More on inheritance and foreign keys

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DCP SD
Тема Re: More on inheritance and foreign keys
Дата
Msg-id E1539E0ED7043848906A8FF995BDA5790116B75D@m0143.s-mxs.net
обсуждение исходный текст
Ответ на More on inheritance and foreign keys  (Albert Cervera Areny <albertca@hotpop.com>)
Ответы Re: More on inheritance and foreign keys  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: Connection Broken with Custom Dicts for TSearch2
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: More on inheritance and foreign keys