Re: [firebird-support] Scope of uniqueness constraint?

2015-04-01 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Tim, Firebird constraints are evaluated immediately for the transaction. So that means that during constraint validation, it doesn't see other transactions, and due to it's immediate evaluation, you can't temporarily ignore validation for your transaction either. (eg: increase all PK

Re: [firebird-support] Scope of uniqueness constraint?

2015-04-01 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Apr 1, 2015, at 5:51 AM, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: (1) Transaction 1 - check for EXXON, find it doesn't exist (2) Transaction 1 - create EXXON (3) Transaction 2 - check for EXXON, find it doesn't exist (because it can't see