Tom Lane wrote:
<[EMAIL PROTECTED]> writes:
I feel lock_timeout it will be a nice feature . Lemme know what would be
the solution of the above problem from existing set of features.
AFAICS statement_timeout would work just fine for that; or you could
use NOWAIT.
ok, you mean we should put statement timeout with statements that potentially lock table exclusively. eg
OTHER SQLS 1.... set statement_timeout = <some reasonable time> DROP TABLE table_name; set statement_timeout = 0; OTHER SQLS 2....
BTW does drop table or alter table have any other reasons to timeout other than waiting for a lock ? In former case the query will get cancelled for an invalid reason.
Regds mallah.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
