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?

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

Sun, 23 Jan 2000 11:33:51 +0200
Constantin Teodorescu <teo@flex.ro>
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sun, 23 Jan 2000 05:04:37 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Unique constraint for inherited tables?