Transaction settings: nowait

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

Responses

Browse pgsql-general by date

  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