Tom Lane wrote:
><mallah@trade-india.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
>
>
>