Is there a nowait option for 'lock table'?

From: u15074 <u15074(at)hs-harz(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Is there a nowait option for 'lock table'?
Date: 2003-03-17 15:36:31
Message-ID: 1047915391.3e75eb7f4ae71@webmail.hs-harz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to lock a certain table within a transaction.
If I have another transaction locking the same table, I don't want it to wait
until the first transaction has finished. I want to get an error so that the
second transaction will be aborted.
In oracle there is an option 'nowait' for table locking, which provides this
functionality.
Is there a way to get this functionality in postgresql or can I query locked
tables?

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-03-17 16:37:33 Re: Feature request for postgresSQL
Previous Message Dekkers Intermediair 2003-03-17 14:53:58 postgreSQL as MSSQL2000 server?