Re: case for lock_timeout

Tom Lane wrote:

><mallah(at)trade-india(dot)com> 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
>
>
>