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: | Raw Message | Whole Thread | 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 |