Re: [HACKERS] Unique constraint for inherited tables?

> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026