Is there a nowait option for 'lock table'? - Mailing list pgsql-general

From u15074
Subject Is there a nowait option for 'lock table'?
Date
Msg-id 1047915391.3e75eb7f4ae71@webmail.hs-harz.de
Whole thread Raw
List 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/


pgsql-general by date:

Previous
From: Trevor Bylsma
Date:
Subject: postmaster has high CPU (system) utilization
Next
From: "Dekkers Intermediair"
Date:
Subject: postgreSQL as MSSQL2000 server?