Restrictions on columns are not being passed to children tables.

Hi there,

I am not sure whether this is a design flaw in the inheritance scheme
of Postgres or a generic problem with DB design (or a problem with
my understanding of inheritance in RDBS :-)

Imagine the following situation:

CREATE TABLE parent ( id INT UNIQUE );
CREATE TABLE child () INHERITS ( parent );
INSERT INTO parent VALUES ( 1 );
INSERT INTO parent VALUES ( 1 ); -- breaks as expected --
INSERT INTO child VALUES( 1 ); -- works, but shouldn't --
INSERT INTO child VALUES( 1 ); -- works even the second time --

SELECT * from parent*; -- not much of a unique, is it? --

Everything is still fine while SELECTing on "parent" instaed of
"parent*". A word of a warning might be useful in the docs :-)

Regards,
Mit freundlichem Gruß,
Holger Klawitter
--
Holger Klawitter +49 (0)251 484 0637
holger(at)klawitter(dot)de http://www.klawitter.de/