Re: Multi-table-unique-constraint

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Multi-table-unique-constraint
Дата
Msg-id 4376D9F2.4050807@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Multi-table-unique-constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Multi-table-unique-constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Most of the people who have thought about this have figured that the
> right solution involves a single index spanning multiple tables (hence,
> adding a table ID to the index entry headers in such indexes).  This
> fixes the lookup and entry problems, but it's not any help for the
> lock-against-schema-mods problem, and it leaves you with a real headache
> if you want to drop just one of the tables.
> 
> 'Tis a hard problem :-(

Maybe the solution is to make inherited tables actually the same table, 
and jank it with an extra per-row attribute to differentiate them or 
something :)

Might make constraint_exclusion less useful then.

Chris


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Samer Abukhait
Дата:
Сообщение: Re: CONNECT BY PRIOR
Следующее
От: Kevin Brown
Дата:
Сообщение: Re: SIGSEGV taken on 8.1 during dump/reload