Is this still true in 7.1? > Helge Bahmann ([EMAIL PROTECTED]) reports a bug with a severity of 4 > The lower the number the more severe it is. > > Short Description > unique/references not honored when inheriting tables > > Long Description > If a table inherits fields carrying the "references" or "unique" constraint, they >are not honoured but silently dropped. It is necessary to manually create the >triggers/indices. > > It would be nice if it were possible to create an index across a table and all >sub-tables. > > > Sample Code > CREATE TABLE foo(id int unique) > CREATE TABLE bar() INHERITS (foo) > INSERT INTO bar VALUES(1) > INSERT INTO bar VALUES(1) > > > No file was uploaded with this report > > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
