Re: Why is AccessShareLock held until end of transaction?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why is AccessShareLock held until end of transaction?
Дата
Msg-id 30114.1394509266@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Why is AccessShareLock held until end of transaction?  (Joe Conway <mail@joeconway.com>)
Ответы Re: Why is AccessShareLock held until end of transaction?  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Дерево обсуждения 
Joe Conway <mail@joeconway.com> writes:
> I am probably missing something obvious, but why does the
> AccessShareLock remain held on a table after a SELECT statement is
> complete when in a transaction block?

*Any* lock acquired by user command is held till end of transaction;
AccessShareLock isn't special.

In general, releasing early would increase the risk of undesirable
behaviors such as tables changing definition mid-transaction.
        regards, tom lane

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [bug fix] pg_ctl always uses the same event source
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: issue log message to suggest VACUUM FULL if a table is nearly empty