Ü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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
