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@klawitter.de                            http://www.klawitter.de/