Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: error-free disabling of individual child partition
- From: Simon Riggs <simon(at)2ndquadrant(dot)com>
- To: Hannu Krosing <hannu(at)skype(dot)net>
- Cc: Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Zeugswetter Andreas DCP SD <ZeugswetterA(at)spardat(dot)at>, Andrew Dunstan <andrew(at)dunslane(dot)net>, April Lorenzen <outboundindex(at)gmail(dot)com>, postgres hackers <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: error-free disabling of individual child partition
- Date: Tue, 23 May 2006 16:26:58 +0100
- Message-id: <1148398018(dot)2646(dot)849(dot)camel(at)localhost(dot)localdomain>
On Tue, 2006-05-23 at 18:19 +0300, Hannu Krosing wrote: > For me "DROP INHERITS oldtable" sounds better than "INHERITS DROP > oldtable" , but it may be just me :) Agreed, so proposal is now ALTER TABLE childN DROP INHERITS old_parent; ALTER TABLE childN ADD INHERITS new_parent; Going once; going twice... -- Simon Riggs EnterpriseDB http://www.enterprisedb.com
- References:
- Re: error-free disabling of individual child partition
- From: Zeugswetter Andreas DCP SD
- Re: error-free disabling of individual child partition
- From: Tom Lane
- Re: error-free disabling of individual child partition
- From: Hannu Krosing
- Re: error-free disabling of individual child partition
- From: Csaba Nagy
- Re: error-free disabling of individual child partition
- From: Simon Riggs
- Re: error-free disabling of individual child partition
- From: Hannu Krosing
- Re: error-free disabling of individual child partition
- Prev by Date: Re: [ADMIN] does wal archiving block the current client
- Next by Date: Re: error-free disabling of individual child partition
- Previous by thread: Re: error-free disabling of individual child partition
- Next by thread: Re: error-free disabling of individual child partition
- Indexes: