> I am defining a table t1 with a NOT NULL field f1 and UNIQUE field f2.
> (it automatically defines t1_f2_key unique index)
>
> I am defining now a new table t2 that inherits t1 table and add some
> columns.
>
> The NOT NULL constraint is preserved for f1 field, the UNIQUE for f2 not
> (the index t2_f2_key) is not defined.
>
> Wouldn't be normal that the unique constraint to be inherited also in
> t2?
This is on the TODO list:
* Unique index on base column not honored on inserts from inherited
table INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail [inherit]
-- Bruce Momjian | http://www.op.net/~candle 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