Re: error-free disabling of individual child partition

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: error-free disabling of individual child partition
Дата
в 12:31:24
Msg-id
8849.1148398265@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: error-free disabling of individual child partition "Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>
Re: error-free disabling of individual child partition Simon Riggs <simon@2ndquadrant.com>
Re: error-free disabling of individual child partition Hannu Krosing <hannu@skype.net>
Re: error-free disabling of individual child partition Tom Lane <tgl@sss.pgh.pa.us>
Re: error-free disabling of individual child partition Hannu Krosing <hannu@skype.net>
Re: error-free disabling of individual child partition Csaba Nagy <nagy@ecircle-ag.com>
Re: error-free disabling of individual child partition Simon Riggs <simon@2ndquadrant.com>
Re: error-free disabling of individual child partition Hannu Krosing <hannu@skype.net>
Re: error-free disabling of individual child partition Simon Riggs <simon@2ndquadrant.com>
Re: error-free disabling of individual child partition Tom Lane <tgl@sss.pgh.pa.us>
Re: error-free disabling of individual child partition Simon Riggs <simon@2ndquadrant.com>
Re: error-free disabling of individual child partition Tom Lane <tgl@sss.pgh.pa.us>
Re: error-free disabling of individual child partition Simon Riggs <simon@2ndquadrant.com>
Re: error-free disabling of individual child partition Hannu Krosing <hannu@skype.net>
Re: error-free disabling of individual child partition Simon Riggs <simon@2ndquadrant.com>
Re: error-free disabling of individual child partition Tom Lane <tgl@sss.pgh.pa.us>
Re: error-free disabling of individual child partition Hannu Krosing <hannu@skype.net>
Re: error-free disabling of individual child partition Alvaro Herrera <alvherre@commandprompt.com>
Re: error-free disabling of individual child partition Tom Lane <tgl@sss.pgh.pa.us>
Re: error-free disabling of individual child partition Andrew Dunstan <andrew@dunslane.net>
Re: error-free disabling of individual child partition Simon Riggs <simon@2ndquadrant.com>
Re: error-free disabling of individual child partition Bruce Momjian <pgman@candle.pha.pa.us>
Re: error-free disabling of individual child partition Tom Lane <tgl@sss.pgh.pa.us>
Re: error-free disabling of individual child partition Simon Riggs <simon@2ndquadrant.com>
Simon Riggs  writes:
> Do we need the ALTER keyword? That isn't used anywhere apart from
> manipulating columns. i.e.

> ALTER TABLE childN INHERITS DROP old_parent;
> ALTER TABLE childN INHERITS ADD new_parent;

At that point it seems like it'd read more naturally the other way
round:

ALTER TABLE childN DROP INHERITS old_parent;
ALTER TABLE childN ADD INHERITS new_parent;

although I'm not sure if this would create a parser conflict against
ADD/DROP COLUMN.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Simon Riggs
Дата:
От: Gavin Hamill
Дата:
FAQ