Is there a nowait option for 'lock table'?

Поиск
Список
Период
Сортировка
От u15074
Тема Is there a nowait option for 'lock table'?
Дата
Msg-id 1047915391.3e75eb7f4ae71@webmail.hs-harz.de
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Trevor Bylsma
Дата:
Сообщение: postmaster has high CPU (system) utilization
Следующее
От: "Dekkers Intermediair"
Дата:
Сообщение: postgreSQL as MSSQL2000 server?