Hi!
In FireBird I can set the transaction to "nowait".
When I want to protect a row for long time (showing a dialog, and on
closing I release the row), I need to do this:
trans.StartTransaction();
sql.execute('update thetable set afield = afield where idfield = anyvalue');
This is locking the ro
On Tue, Feb 28, 2012 at 10:26 AM, Durumdara wrote:
> Hi!
>
> In FireBird I can set the transaction to "nowait".
> When I want to protect a row for long time (showing a dialog, and on
> closing I release the row), I need to do this:
>
> trans.StartTransaction();
> sql.execute('update thetable set a
Dear Filip!
2012/2/28 Filip Rembiałkowski :
> On Tue, Feb 28, 2012 at 10:26 AM, Durumdara wrote:
> Just some loose comments.
>
> http://www.postgresql.org/docs/current/static/explicit-locking.html#LOCKING-ROWS
>
> A way to explicitly lock given row without updating it:
> SELECT whatever FROM thet
On Wed, Feb 29, 2012 at 8:18 AM, Durumdara wrote:
> 2012/2/28 Filip Rembiałkowski :
>> A way to force error when any statement takes more than 200 msec:
>> SET statement_timeout TO '200ms';
>
> As I see that is not needed here.
> Only for normal updates.
>
> And how I can "reset" statement_timeo