Hi!
In FireBird the transactions have these settings:
SET TRANSACTION [NAME hostvar] [READ WRITE | READ ONLY] [ [ISOLATION LEVEL] { SNAPSHOT [TABLE STABILITY] | READ COMMITTED [[NO] RECORD_VERSION] } ] [WAIT | NO WAIT] [LOCK TIMEOUT seconds]
And this is the important thing:
[WAIT | NO WAIT] [LOCK TIMEOUT seconds]
If set wait and timeout, the Firebird is waiting for the locked resource (record) for X seconds before it show deadlock error.
But when you set no wait, the deadlock error immediately shown by the server.
I wanna ask that if I want to avoid the full deadlocks.
For. example: I forget to make commit, or rollback on exception then all resources I used (updated) is locked.
If I use nowait, the clients immediately get the error message, and they are are not sitting deafly and blindly before the screen, waiting for what will happen.
So: have PGSQL same mechanism like nowait?
Thanks for your help:
dd