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

pgsql: Centralize some ALTER <whatever> .. SET SCHEMA checks.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Centralize some ALTER <whatever> .. SET SCHEMA checks.
Date: 2010-11-23 01:00:55
Message-ID: E1PKhFf-0001Y6-Q3@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Centralize some ALTER <whatever> .. SET SCHEMA checks.

Any flavor of ALTER <whatever> .. SET SCHEMA fails if (1) the object
is already in the new schema, (2) either the old or new schema is
a temp schema, or (3) either the old or new schema is the TOAST schema.

Extraced from a patch by Dimitri Fontaine, with additional hacking by me.

Branch
------
master

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

Modified Files
--------------
src/backend/catalog/dependency.c    |   15 +++++++++++++++
src/backend/catalog/namespace.c     |   34 ++++++++++++++++++++++++++++++++++
src/backend/commands/functioncmds.c |   20 ++------------------
src/backend/commands/tablecmds.c    |   20 ++------------------
src/backend/commands/typecmds.c     |   20 ++------------------
src/include/catalog/dependency.h    |    1 +
src/include/catalog/namespace.h     |    2 ++
7 files changed, 58 insertions(+), 54 deletions(-)

pgsql-committers by date

Next:From: Peter EisentrautDate: 2010-11-23 20:52:18
Subject: pgsql: Remove useless whitespace at end of lines
Previous:From: Alvaro HerreraDate: 2010-11-22 22:01:34
Subject: pgsql: Remove GucContext parameter from ParseConfigFile

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