Thanks Peter, I will submit this.

John

--- In firebird-support@yahoogroups.com, "peter_jacobi.rm"
<peter_jacobi@g...> wrote:

> "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