Re: BUG #15446: Crash on ALTER TABLE

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: BUG #15446: Crash on ALTER TABLE
Дата
Msg-id
20190105170940.2qrbilpxmmxyf4tr@alap3.anarazel.de
Ответ на
Re: BUG #15446: Crash on ALTER TABLE (Dean Rasheed)
Список
Дерево обсуждения
BUG #15446: Crash on ALTER TABLE PG Bug reporting form <noreply@postgresql.org>
Re: BUG #15446: Crash on ALTER TABLE Andres Freund <andres@anarazel.de>
Re: BUG #15446: Crash on ALTER TABLE Dmitry Molotkov <aldarund@gmail.com>
Re: BUG #15446: Crash on ALTER TABLE Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #15446: Crash on ALTER TABLE Dmitry Molotkov <aldarund@gmail.com>
Re: BUG #15446: Crash on ALTER TABLE Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #15446: Crash on ALTER TABLE Dmitry Molotkov <aldarund@gmail.com>
Re: BUG #15446: Crash on ALTER TABLE Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #15446: Crash on ALTER TABLE Dmitry Molotkov <aldarund@gmail.com>
Re: BUG #15446: Crash on ALTER TABLE Dmitry Molotkov <aldarund@gmail.com>
Re: BUG #15446: Crash on ALTER TABLE Andres Freund <andres@anarazel.de>
Re: BUG #15446: Crash on ALTER TABLE Dmitry Molotkov <aldarund@gmail.com>
Re: BUG #15446: Crash on ALTER TABLE Andres Freund <andres@anarazel.de>
Re: BUG #15446: Crash on ALTER TABLE Dmitry Molotkov <aldarund@gmail.com>
Re: BUG #15446: Crash on ALTER TABLE Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #15446: Crash on ALTER TABLE Dean Rasheed <dean.a.rasheed@gmail.com>
Re: BUG #15446: Crash on ALTER TABLE Andres Freund <andres@anarazel.de>
Re: BUG #15446: Crash on ALTER TABLE Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: BUG #15446: Crash on ALTER TABLE Michael Paquier <michael@paquier.xyz>
Re: BUG #15446: Crash on ALTER TABLE Magnus Hagander <magnus@hagander.net> 
Hi,

On 2019-01-05 12:11:45 +0000, Dean Rasheed wrote:
> It looks like the problem was introduced in PG11 by 16828d5c02 (Fast
> ALTER TABLE ADD COLUMN with a non-NULL default). The first ALTER TABLE
> adds a new column with a non-null default, setting atthasmissing and
> attmissingval. Then the second ALTER TABLE changes the type of the new
> column, but it fails to update attmissingval to match, and thus it
> falls over when trying to re-open the relation because the value in
> attmissingval is no longer compatible with the attribute type.

Paging Dr Dunstan.

Greetings,

Andres Freund
В списке pgsql-bugs по дате отправления
Предыдущее
От: Phil Hildebrand
Дата:
Следующее
От: PG Bug reporting form
Дата:
FAQ