Subject Re: 2 identical record inserts not stopped by UNIQUE constraint
Author Stan
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
>
> > This is not just happening in one transaction,
> >
> > I open a new isql session and I see the 2 records.
> >
> > I run: gfix -commit all
> >
> > and opened a new isql and I still see the 2 record.
> >
> > This means that the database actually has the 2 records, correct?
> >
> > thanks,
> >
> > stan
> >
>
> can you check if the unique constraint is active?

It is active.

> Alan
>