Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMN

Enterprise / PostgreSQL - Andrew Dunstan [dunslane.net] - 29 July 2015 20:30 UTC

Fabrízio de Royes Mello, reviewed by Payal Singh, Alvaro Herrera and Michael Paquier.

2cd40ad Add IF NOT EXISTS processing to ALTER TABLE ADD COLUMN
doc/src/sgml/ref/alter_table.sgml | 8 ++-
src/backend/commands/tablecmds.c | 52 ++++++++++++-----
src/backend/parser/gram.y | 20 +++++++
src/test/regress/expected/alter_table.out | 89 +++++++++++++++++++++++++++++
src/test/regress/sql/alter_table.sql | 31 ++++++++++
5 files changed, 182 insertions(+), 18 deletions(-)

Upstream: git.postgresql.org


  • Share