[firebird-support] Cannot restore primary key constraint after removing

2013-11-22 Thread scottb
Greetings all, I am removing a primary key constraint in order to speed up an import of many records. After the import, I commit all changes, and then restore the primary key to my table with this: ALTER TABLE CHARGE ADD CONSTRAINT PK_CHARGE PRIMARY KEY (CHARGE_TABLE_ID) The statem

[firebird-support] Cannot restore primary key after removing it

2013-11-22 Thread scottb
Hi, I am experiencing a problem when I try to restore a primary key constraint after removing it. I am removing it to speed up the import I am doing. (perhaps this does not speed things up so much ?) Anyways here is what it looks like in general: ALTER TABLE CHARGE DROP CONSTRAINT PK_CHAR