Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"
Дата
Msg-id 1290105030-sup-5154@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
Дерево обсуждения 
Excerpts from Robert Haas's message of jue nov 18 15:11:37 -0300 2010:

> In the current master branch, it appears that "ALTER TABLE c INHERIT
> p" takes a ShareUpdateExclusiveLock on the child, which seems
> sufficient, and an AccessShareLock on the parent, which seems like it
> might not be; though I'm having a hard time figuring out exactly when
> it wouldn't be, especially since in 8.4 I'm fairly sure any ALTER
> TABLE command takes an AccessExclusiveLock.

What if two of these run at the same time, and the parent doesn't
have children when they start?  They would both try to set
relhassubclass, no?

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"