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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"
Дата
Msg-id 1290105289-sup-6685@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"  (Robert Haas <robertmhaas@gmail.com>)
Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
Дерево обсуждения 
Excerpts from Alvaro Herrera's message of jue nov 18 15:31:16 -0300 2010:
> 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?

Yep, duplicated the issue that way.

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

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Problem with ALTER TABLE - occasional "tuple concurrently updated"
Следующее
От: "Andrey G."
Дата:
Сообщение: Re: BUG #5757: PL/PGSQL composite variable field error reporting