[firebird-support] Re: Deadlock exception occurs but it shouldn't?

2014-12-29 Thread hv...@users.sourceforge.net [firebird-support]
Walter, there are few reasons: a) MVCC engine never block records - it just can't :) b) the only way to disable concurrent updates of the same record is... update :) More exactly: engine must mark primary record version by current transaction and it will make concurrent writes wait or

Re: [firebird-support] Re: Deadlock exception occurs but it shouldn't?

2014-12-29 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Thank you for your explanation Vlad, the proccess is more clear for me now. Greatings. Walter. On Mon, Dec 29, 2014 at 4:55 AM, hv...@users.sourceforge.net [firebird-support] firebird-support@yahoogroups.com wrote: Walter, there are few reasons: a) MVCC engine never block records - it

[firebird-support] Check constraints vs. user defined triggers

2014-12-29 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Hi, I have a table with four check constraints, which basically check logical conditions between its fields. In order to enforce those constraints, Firebird creates behind the scenes two triggers for each one of them (I suppose one for update and the other for insert operation). So in this

[firebird-support] Request depth exceeded problem

2014-12-29 Thread Josef Kokeš j.ko...@apatykaservis.cz [firebird-support]
Hi! I am having trouble with one installation of my application: Whenever I try to create a table, I receive error 335544351 unsuccessful metadata update\nrequest depth exceeded. (Recursive definition?). I cannot figure what could possibly be causing this, as the CREATE TABLE statement is