Re: error-free disabling of individual child partition - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: error-free disabling of individual child partition
Date
Msg-id 1148457815.3843.1.camel@localhost.localdomain
Whole thread Raw
In response to Re: error-free disabling of individual child partition  ("Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
Ühel kenal päeval, K, 2006-05-24 kell 09:56, kirjutas Zeugswetter
Andreas DCP SD:
> > Added to TODO:
> > 
> >         o Add ALTER TABLE tab ADD/DROP INHERITS parent
> 
> Sounds good, more inline with add/drop constraint.
> 
> >           pg_attribute.attislocal has to be set to 'false' for ADD,
> and
> >> attislocal: If you set this to False, you wouldn't be able to set it
> >> back again.
> 
> Just curious, why is that ?
> 
> >           pg_attribute.attinhcount adjusted appropriately
> 
> Do we have a plan on what to do with RI constraints on the parent
> when doing DROP INHERTITS ? 

I think this is out of scope of this discussion, as we do not currently
support RI over inherited tables. IOW RI is always on one table ONLY.

-- 
----------------
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 by date:

Previous
From: "Zeugswetter Andreas DCP SD"
Date:
Subject: Re: error-free disabling of individual child partition
Next
From: Gavin Hamill
Date:
Subject: Re: Further reduction of bufmgr lock contention