Re: [BUGS] unique/references not honored when inheriting tables

Is this still true in 7.1?


> Helge Bahmann (bahmann@math.tu-freiberg.de) 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 pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026