Re: default child of partition master

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: default child of partition master
Дата
Msg-id 27782.1156090169@sss.pgh.pa.us
обсуждение исходный текст
Ответ на default child of partition master  ("April Lorenzen" <outboundindex@gmail.com>)
Ответы Re: default child of partition master
Список pgsql-hackers
"April Lorenzen" <outboundindex@gmail.com> writes:
> My suggestion is to allow specifying a default destination table in
> the master partition table definition. This default destination table
> could be changed with ALTER TABLE.

The recommended way to do this is with an ON INSERT DO INSTEAD rule
on the master table.  The advantage of using rules is that you can have
several conditional rules to ensure that insertions go into the right
sub-tables, whereas a default would likely just fail :-(
        regards, tom lane


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

Предыдущее
От: "April Lorenzen"
Дата:
Сообщение: default child of partition master
Следующее
От: Gene
Дата:
Сообщение: Re: default child of partition master