OSDN Git Service

Create 'default_tablespace' GUC variable that supplies a TABLESPACE
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 5 Nov 2004 19:17:13 +0000 (19:17 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 5 Nov 2004 19:17:13 +0000 (19:17 +0000)
commit98e8b4805324d8ba0b196b8ffaafd5ddd3051ea1
tree61d027f5621f3ff37a675fb2e9982e0d28a81242
parent0ed3c7665e2fe46efd3eef936a1265be2ec6707f
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.
37 files changed:
contrib/oid2name/oid2name.c
doc/src/sgml/catalogs.sgml
doc/src/sgml/manage-ag.sgml
doc/src/sgml/ref/create_index.sgml
doc/src/sgml/ref/create_schema.sgml
doc/src/sgml/ref/create_table.sgml
doc/src/sgml/ref/create_tablespace.sgml
doc/src/sgml/ref/grant.sgml
doc/src/sgml/ref/revoke.sgml
doc/src/sgml/release.sgml
doc/src/sgml/runtime.sgml
src/backend/catalog/namespace.c
src/backend/catalog/pg_namespace.c
src/backend/commands/indexcmds.c
src/backend/commands/schemacmds.c
src/backend/commands/tablecmds.c
src/backend/commands/tablespace.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/backend/utils/adt/ruleutils.c
src/backend/utils/cache/lsyscache.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/bin/pg_dump/pg_dump.c
src/bin/pg_dump/pg_dump.h
src/bin/psql/describe.c
src/bin/psql/tab-complete.c
src/include/catalog/catversion.h
src/include/catalog/pg_namespace.h
src/include/commands/tablespace.h
src/include/nodes/parsenodes.h
src/include/utils/guc.h
src/include/utils/lsyscache.h
src/interfaces/ecpg/preproc/preproc.y
src/test/regress/input/tablespace.source
src/test/regress/output/tablespace.source