pgsql: Add ALTER object SET SCHEMA capability for a limited but useful

Started by Tom Lanealmost 21 years ago2 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

Log Message:
-----------
Add ALTER object SET SCHEMA capability for a limited but useful set of
object kinds (tables, functions, types). Documentation is not here yet.
Original code by Bernd Helmle, extensive rework by Bruce Momjian and
Tom Lane.

Modified Files:
--------------
pgsql/src/backend/catalog:
namespace.c (r1.76 -> r1.77)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/namespace.c.diff?r1=1.76&r2=1.77)
pg_constraint.c (r1.25 -> r1.26)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_constraint.c.diff?r1=1.25&r2=1.26)
pg_depend.c (r1.13 -> r1.14)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_depend.c.diff?r1=1.13&r2=1.14)
pgsql/src/backend/commands:
alter.c (r1.13 -> r1.14)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/alter.c.diff?r1=1.13&r2=1.14)
functioncmds.c (r1.64 -> r1.65)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/functioncmds.c.diff?r1=1.64&r2=1.65)
tablecmds.c (r1.164 -> r1.165)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c.diff?r1=1.164&r2=1.165)
typecmds.c (r1.76 -> r1.77)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/typecmds.c.diff?r1=1.76&r2=1.77)
pgsql/src/backend/nodes:
copyfuncs.c (r1.313 -> r1.314)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c.diff?r1=1.313&r2=1.314)
equalfuncs.c (r1.250 -> r1.251)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c.diff?r1=1.250&r2=1.251)
pgsql/src/backend/parser:
gram.y (r2.505 -> r2.506)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.505&r2=2.506)
pgsql/src/backend/tcop:
utility.c (r1.242 -> r1.243)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/utility.c.diff?r1=1.242&r2=1.243)
pgsql/src/include/catalog:
dependency.h (r1.15 -> r1.16)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/dependency.h.diff?r1=1.15&r2=1.16)
namespace.h (r1.35 -> r1.36)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/namespace.h.diff?r1=1.35&r2=1.36)
pg_constraint.h (r1.16 -> r1.17)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_constraint.h.diff?r1=1.16&r2=1.17)
pgsql/src/include/commands:
alter.h (r1.6 -> r1.7)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/alter.h.diff?r1=1.6&r2=1.7)
defrem.h (r1.66 -> r1.67)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/defrem.h.diff?r1=1.66&r2=1.67)
tablecmds.h (r1.22 -> r1.23)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/tablecmds.h.diff?r1=1.22&r2=1.23)
typecmds.h (r1.11 -> r1.12)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/typecmds.h.diff?r1=1.11&r2=1.12)
pgsql/src/include/nodes:
nodes.h (r1.173 -> r1.174)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/nodes.h.diff?r1=1.173&r2=1.174)
parsenodes.h (r1.287 -> r1.288)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h.diff?r1=1.287&r2=1.288)
pgsql/src/test/regress/expected:
alter_table.out (r1.88 -> r1.89)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/alter_table.out.diff?r1=1.88&r2=1.89)
pgsql/src/test/regress/sql:
alter_table.sql (r1.51 -> r1.52)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/alter_table.sql.diff?r1=1.51&r2=1.52)

#2Bernd Helmle
mailings@oopsware.de
In reply to: Tom Lane (#1)
Re: pgsql: Add ALTER object SET SCHEMA capability for

--On Montag, August 01, 2005 01:03:59 -0300 Tom Lane
<tgl@svr1.postgresql.org> wrote:

Add ALTER object SET SCHEMA capability for a limited but useful set of
object kinds (tables, functions, types). Documentation is not here yet.
Original code by Bernd Helmle, extensive rework by Bruce Momjian and
Tom Lane.

Uff, your changes makes the code _much_ more cleaner than my shot,
especially the SERIAL and index stuff :)

Thank you for considering.

--
Bernd