Create 'default_tablespace' GUC variable that supplies a TABLESPACE

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 98e8b4805324d8ba0b196b8ffaafd5ddd3051ea1
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2004-11-05T19:17:13Z
Releases: 8.0.0
Create 'default_tablespace' GUC variable that supplies a TABLESPACE
clause implicitly whenever one is not given explicitly.  Remove concept
of a schema having an associated tablespace, and simplify the rules for
selecting a default tablespace for a table or index.  It's now just
(a) explicit TABLESPACE clause; (b) default_tablespace if that's not an
empty string; (c) database's default.  This will allow pg_dump to use
SET commands instead of tablespace clauses to determine object locations
(but I didn't actually make it do so).  All per recent discussions.

Files

PathChange+/−
contrib/oid2name/oid2name.c modified +8 −8
doc/src/sgml/catalogs.sgml modified +1 −12
doc/src/sgml/manage-ag.sgml modified +22 −33
doc/src/sgml/ref/create_index.sgml modified +4 −2
doc/src/sgml/ref/create_schema.sgml modified +4 −27
doc/src/sgml/ref/create_table.sgml modified +11 −5
doc/src/sgml/ref/create_tablespace.sgml modified +3 −4
doc/src/sgml/ref/grant.sgml modified +13 −13
doc/src/sgml/ref/revoke.sgml modified +7 −7
doc/src/sgml/release.sgml modified +3 −3
doc/src/sgml/runtime.sgml modified +27 −1
src/backend/catalog/namespace.c modified +2 −2
src/backend/catalog/pg_namespace.c modified +2 −3
src/backend/commands/indexcmds.c modified +27 −13
src/backend/commands/schemacmds.c modified +2 −31
src/backend/commands/tablecmds.c modified +16 −53
src/backend/commands/tablespace.c modified +144 −81
src/backend/nodes/copyfuncs.c modified +1 −2
src/backend/nodes/equalfuncs.c modified +1 −2
src/backend/parser/gram.y modified +5 −7
src/backend/utils/adt/ruleutils.c modified +1 −110
src/backend/utils/cache/lsyscache.c modified +1 −57
src/backend/utils/misc/guc.c modified +11 −1
src/backend/utils/misc/postgresql.conf.sample modified +1 −0
src/bin/pg_dump/pg_dump.c modified +13 −57
src/bin/pg_dump/pg_dump.h modified +1 −2
src/bin/psql/describe.c modified +4 −4
src/bin/psql/tab-complete.c modified +2 −1
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/pg_namespace.h modified +7 −10
src/include/commands/tablespace.h modified +4 −1
src/include/nodes/parsenodes.h modified +1 −2
src/include/utils/guc.h modified +5 −1
src/include/utils/lsyscache.h modified +1 −3
src/interfaces/ecpg/preproc/preproc.y modified +5 −5
src/test/regress/input/tablespace.source modified +4 −8
src/test/regress/output/tablespace.source modified +4 −12