Thread: Is there a nowait option for 'lock table'?

Is there a nowait option for 'lock table'?

From
u15074
Date:
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/