Re: ALTER TABLE with multiple SET NOT NULL
От
Sergei Kornilov
Тема
Re: ALTER TABLE with multiple SET NOT NULL
Дата
Msg-id
1189371547032318@sas2-80cfc068821c.qloud-c.yandex.net
Ответ на
Re: ALTER TABLE with multiple SET NOT NULL (Tom Lane)
Список
Hello I investigate this bug and found reason: > alter table t1 add column b float8 not null default random(), add primary key(a); Here we call ATController (src/backend/commands/tablecmds.c) with two cmds: AT_AddColumn and AT_AddIndex Then we go to phase 2 in ATRewriteCatalogs: - succesful add new attribute, but without table rewrite - it will be later in phase 3 - call ATExecAddIndex, we want add primary key, so we call index_check_primary_key. index_check_primary_key call AlterTableInternal and therefore another ATController with independent one AT_SetNotNull command. ATController will call phase 2, and then its own phase 3 with validation all constraints. But at this nested level we have no AlteredTableInfo->newvals and we do not proper transform tuple. not sure how we can proper rewrite this case. regards, Sergei
В списке pgsql-hackers по дате отправления
От: Michael Banck
Дата:
От: Magnus Hagander
Дата: