From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | unique/references not honored when inheriting tables |
Date: | 2000-09-02 20:00:01 |
Message-ID: | 200009022000.e82K01U25497@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Helge Bahmann (bahmann(at)math(dot)tu-freiberg(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Benjamin | 2000-09-03 04:44:05 | Re: PG still fussy to compile on Solaris + GCC, may still need Sun ld |
Previous Message | Tom Lane | 2000-09-02 19:49:58 | Re: PG still fussy to compile on Solaris + GCC, may still need Sun ld |
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Christensen | 2000-09-02 21:05:45 | Re: [Solved] SQL Server to PostgreSQL |
Previous Message | The Hermit Hacker | 2000-09-02 19:21:50 | Re: Isn't non-TEST_AND_SET code long dead? |