pgsql: Remove arbitrary ALTER TABLE .. ADD COLUMN restriction. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Remove arbitrary ALTER TABLE .. ADD COLUMN restriction.
Date
Msg-id E1Pi3gd-0001Cs-VO@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgsql: Update warning about synchronous-commit durability, per suggesti
Next
From: Robert Haas
Date:
Subject: pgsql: Add a comment explaining why we force physical removal of OIDs.