Subject | Re: 2 identical record inserts not stopped by UNIQUE constraint |
---|---|
Author | Stan |
Post date | 2006-10-24T21:44:08Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
>It is active.
> > 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?
> Alan
>