Subject Re: [Firebird-Java] Duplicate primary keys v1.5.1
Author Roman Rokytskyy
Hi,


> I used a stored procedure to import a lot of data, and got quite a
> surprise when I viewed it. Every imported record was in the table,
> including duplicates! Looking at the statistics for the primary
> key, it shows that it wasn't used.

This is support question, for more details please ask in Firebird-Support.

> I wasn't aware that a PK could be turned off, or how to turn it back on
> now that it's off. Gfix -v -n didn't return any messages.

PK constraint is based on unique index definition. Index can be turned
inactive using the ALTER INDEX name {ACTIVE | INACTIVE}. Name can be found
as SELECT rdb$index_name FROM rdb$indices WHERE rdb$relation_name =
'MDDB_GPI' (see Language Refernce for more info).

Roman