Re: timeout on lock feature

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: timeout on lock feature
Дата
Msg-id 4547.987180295@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: timeout on lock feature  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: timeout on lock feature  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I can imagine some people wanting this.  However, 7.1 has new deadlock
> detection code, so I would you make a 7.1 version and send it over.  We
> can get it into 7.2.

I object strongly to any such "feature" in the low-level form that
Henryk proposes, because it would affect *ALL* locking.  Do you really
want all your other transactions to go belly-up if, say, someone vacuums
pg_class?

A variant of LOCK TABLE that explicitly requests a timeout might make
sense, though.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Yellow Dog Linux/PPC regression
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: HOLD THE PRESSES!! ... pg_dump from v7.0.3 can't import to v7.1?