I am using FB RC3 without NPTL support on SLES 9.
I get the error message "ERROR: attempt to store duplicate value (visible
to active transactions) in unique index " when I try to create unique
index on VarChar column in table with no duplicates. I even emptied out
the table and then tried to create the index but got the same message:
Code:
ALTER TABLE REFERRAL ADD CONSTRAINT REFERRALBYREFERRALCODE UNIQUE
(REFERRALCODE);
Result:
ERROR: attempt to store duplicate value (visible
to active transactions) in unique index
"REFERRALBYREFERRALCODE ".
I spent about an hour checking system tables and trying to pinpoint the
issue. Then I restarted the firebird server and tried again and all went
fine. Seems like there was an active transaction that did not let me do
it. I did not check outstanding transactions before restart so I dont
know for sure.
--
Mike Starov
mikestarov@...
CME Resource, Inc.
Roseville, CA 95661
www.netce.com
(916) 783-4238
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test
