| From: | durumdara <durumdara(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Transaction settings: nowait | 
| Date: | 2009-05-06 09:19:47 | 
| Message-ID: | 4A015633.9070502@gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ml | 2009-05-06 12:31:15 | tsearch2 memory problem | 
| Previous Message | Slansky Lukas | 2009-05-06 08:07:15 | Re: PGSQL x iptables |