Subject | Re: [firebird-support] Unable to create unique constraint |
---|---|
Author | André Knappstein |
Post date | 2014-03-21T12:09:32Z |
> Oops, I forgot index problems could lead to there being NULL orSET and Thomas, thanks for the answer.
> duplicates in the PK field, so change the above query to:
> select
> T.F1+0,
> T.F2+0,
> count(*)
> from
> T
> group by
> 1, 2
> having
> count(*) > 1
The above select statement was only to make sure that no duplicates
are still in the table.
The table is a completely new creation, and nobody else could have
been using it besides me, although the database itself is the original
production database used by some 50 concurrent users.
I disconnected and reconnected, even did a backup (to "visit" each
record) and explicit sweep and made sure noone else was connected
to the database late in the evening. No success.
Today anyway, the problem dissolved into nothingness. I could suddenly
create the UnC quite fine. Go figure...
Thank you anyway, guys.