Remove arbitrary ALTER TABLE .. ADD COLUMN restriction. The previous coding prevented ALTER TABLE .. ADD COLUMN from being used with a non-NULL default in situations where the table's rowtype was being used elsewhere. But this is a completely arbitrary restriction since you could do the same operation in multiple steps (add the column, add the default, update the table).
Inspired by a patch from Noah Misch, though I didn't use his code. Branch ------ master Details ------- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=a06e41deebdf74b8b5109329dc75b2e9d9057962 Modified Files -------------- src/backend/commands/tablecmds.c | 8 +++++--- src/test/regress/expected/rowtypes.out | 9 ++++++--- src/test/regress/sql/rowtypes.sql | 8 ++++++-- 3 files changed, 17 insertions(+), 8 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
