"Martijn Tonies" <m.tonies@u...> wrote:

> ALTER TABLE UN_TEST ADD CONSTRAINT C_UN_TEST
> CHECK (
>
> not exists (select ut.* from UN_TEST ut where new.UNIQUE_COL =

ut.UNIQUE_COL

> and ut.PKCOL <> new.PKCOL)

I'd assume this constraint would be better served
by a DEFERRABLE, INITIALLY DEFERRED option, but aside
from reserving the keywords, nothing is implemented yet.

Anyway, I also think that it just shouldn't be possible
to insert records with violating this constraint, so this
should go into the bug tracker.

Regards,
Peter Jacobi