Re: Problem with unique constraint creation

> When you create a constraint that you wish to enable novalidate, it must
be
> *deferrable* (but can be set deferrable initially immediate which is the
> default).
>
> Change your statement to something like:
>
> alter table x add (constraint x_col_unique (col) deferrable enable
> novalidate);

OK but *deferrable* waits till the end of transaction, doesn't it ? Is it possible to create a unique constraint on the table with the duplicated rows ???

Regards
EP Received on Fri Jul 12 2002 - 06:51:26 CDT