unique/references not honored when inheriting tables - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject unique/references not honored when inheriting tables
Date
Msg-id 200009022000.e82K01U25497@hub.org
Whole thread Raw
Responses Re: unique/references not honored when inheriting tables  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG still fussy to compile on Solaris + GCC, may still need Sun ld
Next
From: Tom Lane
Date:
Subject: Re: PG still fussy to compile on Solaris + GCC, may still need Sun ld