| From: | Hannu Krosing <hannu(at)skype(dot)net> |
|---|---|
| To: | Zeugswetter Andreas DCP SD <ZeugswetterA(at)spardat(dot)at> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Csaba Nagy <nagy(at)ecircle-ag(dot)com>, 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: | 2006-05-24 08:03:35 |
| Message-ID: | 1148457815.3843.1.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Hamill | 2006-05-24 08:14:47 | Re: Further reduction of bufmgr lock contention |
| Previous Message | Zeugswetter Andreas DCP SD | 2006-05-24 07:56:05 | Re: error-free disabling of individual child partition |