Subject | Re: [Firebird-Java] Duplicate primary keys v1.5.1 |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-10-22T17:44:04Z |
Hi,
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
> I used a stored procedure to import a lot of data, and got quite aThis is support question, for more details please ask in Firebird-Support.
> 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.
> I wasn't aware that a PK could be turned off, or how to turn it back onPK constraint is based on unique index definition. Index can be turned
> now that it's off. Gfix -v -n didn't return any messages.
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