Skip site navigation (1) Skip section navigation (2)

pgsql: Propagate ALTER TYPE operations to typed tables

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Propagate ALTER TYPE operations to typed tables
Date: 2010-11-23 20:52:18
Message-ID: E1PKzqc-00018Q-Rq@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Propagate ALTER TYPE operations to typed tables

This adds RESTRICT/CASCADE flags to ALTER TYPE ... ADD/DROP/ALTER/
RENAME ATTRIBUTE to control whether to alter typed tables as well.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=f2a4278330ae12cd56b61c92a7debb9c9fca7b41

Modified Files
--------------
doc/src/sgml/ref/alter_type.sgml          |   28 +++++-
src/backend/commands/alter.c              |    6 +-
src/backend/commands/tablecmds.c          |  151 +++++++++++++++++++++--------
src/backend/nodes/copyfuncs.c             |    1 +
src/backend/nodes/equalfuncs.c            |    1 +
src/backend/parser/gram.y                 |   23 +++--
src/include/commands/tablecmds.h          |    6 +-
src/include/nodes/parsenodes.h            |    1 +
src/test/regress/expected/alter_table.out |   89 +++++++++++++++++-
src/test/regress/sql/alter_table.sql      |   20 ++++-
10 files changed, 258 insertions(+), 68 deletions(-)

pgsql-committers by date

Next:From: Peter EisentrautDate: 2010-11-23 22:03:54
Subject: pgsql: Add index entries for more functions
Previous:From: Robert HaasDate: 2010-11-23 01:00:55
Subject: pgsql: Centralize some ALTER <whatever> .. SET SCHEMA checks.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group