Hannu Krosing wrote: > ?hel kenal p?eval, E, 2006-03-06 kell 12:12, kirjutas Bruce Momjian: > > Added to TODO: > > > > o Prevent parent tables from altering or dropping constraints > > like CHECK that are inherited by child tables > > > > Dropping constraints should only be possible with CASCADE. > > > > and we already have this in TODO: > > > > o %Prevent child tables from altering or dropping constraints > > like CHECK that were inherited from the parent table > > > > so I think we now have all the failure cases documented. > > If you want to be consistent, then ALTER TABLE ONLY ADD CONSTRAINT .. > should also be forbidden, so you can't create non-inherited constraints
I don't have a problem with creating ONLY constraints on parents and children. We just don't want them to be removed/modified if they are shared. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly