Re: Questions relating to "modified while in use" messages

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Questions relating to "modified while in use" messages
Дата
Msg-id 29890.963505068@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Questions relating to "modified while in use" messages  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-hackers
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> Of course, I also really only noticed it when I ran the two really
> close together or the alter table inside a transaction.

Right, the problem only comes up if the report of the table change
arrives at the other backend just as it's preparing to start a new
transaction on that same table.  If the other backend's first table
lock after the ALTER commits is on some other table, no problem.

We do need to fix it but I think there are higher-priority problems...
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Temp tables performance question
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Temp tables performance question