Re: error-free disabling of individual child partition
От | Hannu Krosing |
---|---|
Тема | Re: error-free disabling of individual child partition |
Дата | |
Msg-id | 1148393330.3798.18.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: error-free disabling of individual child partition (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: error-free disabling of individual child partition
Re: error-free disabling of individual child partition |
Список | pgsql-hackers |
Ühel kenal päeval, T, 2006-05-23 kell 09:37, kirjutas Tom Lane: > "Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at> writes: > >>> We don't need a disinherit do we? > > > I propose: ALTER TABLE childN INHERITS (); > > Thus I also think, that the list should be complete, and is not an > > addition to existing inheritance. > > Don't like that at all: it seems far too error-prone. In what way ? Do you mean that it will be easy for the user to make errors, od do yuo think that it will be hard to implement in a robust way ? In the first case, I'd propose following syntax ALTER TABLE childN ALTER INHERITS DROP (parent); ALTER TABLE childN ALTER INHERITS ADD (parent); With this syntax reparenting would need an explicit transaction and two "ALTER TABLE ... ALTER INHERITS ..." commands, but it is (arguably) harder to make mistakes. -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com
В списке pgsql-hackers по дате отправления: