pgsql: Fix handling of generated columns in ALTER TABLE.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Fix handling of generated columns in ALTER TABLE.
Дата
Msg-id E1ipCYH-00012S-VT@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix handling of generated columns in ALTER TABLE.

ALTER TABLE failed if a column referenced in a GENERATED expression
had been added or changed in type earlier in the ALTER command.
That's because the GENERATED expression needs to be evaluated
against the table's updated tuples, but it was being evaluated
against the original tuples.  (Fortunately the executor has adequate
cross-checks to notice the mismatch, so we just got an obscure error
message and not anything more dangerous.)

Per report from Andreas Joseph Krogh.  Back-patch to v12 where
GENERATED was added.

Discussion: https://postgr.es/m/VisenaEmail.200.231b0a41523275d0.16ea7f800c7@tc7-visena

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4ac8aaa36fa24639989849c8109f8b52e9544fd1

Modified Files
--------------
src/backend/commands/tablecmds.c        | 33 ++++++++++-
src/test/regress/expected/generated.out | 97 ++++++++++++++++++++++++++-------
src/test/regress/sql/generated.sql      | 31 +++++++++--
3 files changed, 132 insertions(+), 29 deletions(-)


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: pgbench: Use common logging API
Следующее
От: Stephen Frost
Дата:
Сообщение: pgsql: Improve GSSAPI Encryption startup comment in libpq