pgsql: Create 'default_tablespace' GUC variable that supplies a - Mailing list pgsql-committers
From | tgl@svr1.postgresql.org (Tom Lane) |
---|---|
Subject | pgsql: Create 'default_tablespace' GUC variable that supplies a |
Date | |
Msg-id | 20041105191731.9569D3A3E49@svr1.postgresql.org Whole thread Raw |
List | pgsql-committers |
Log Message: ----------- 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. Modified Files: -------------- pgsql/contrib/oid2name: oid2name.c (r1.24 -> r1.25) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/oid2name/oid2name.c.diff?r1=1.24&r2=1.25) pgsql/doc/src/sgml: catalogs.sgml (r2.90 -> r2.91) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml.diff?r1=2.90&r2=2.91) manage-ag.sgml (r2.35 -> r2.36) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/manage-ag.sgml.diff?r1=2.35&r2=2.36) release.sgml (r1.303 -> r1.304) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.303&r2=1.304) runtime.sgml (r1.290 -> r1.291) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/runtime.sgml.diff?r1=1.290&r2=1.291) pgsql/doc/src/sgml/ref: create_index.sgml (r1.49 -> r1.50) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_index.sgml.diff?r1=1.49&r2=1.50) create_schema.sgml (r1.15 -> r1.16) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_schema.sgml.diff?r1=1.15&r2=1.16) create_table.sgml (r1.85 -> r1.86) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_table.sgml.diff?r1=1.85&r2=1.86) create_tablespace.sgml (r1.4 -> r1.5) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_tablespace.sgml.diff?r1=1.4&r2=1.5) grant.sgml (r1.43 -> r1.44) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/grant.sgml.diff?r1=1.43&r2=1.44) revoke.sgml (r1.31 -> r1.32) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/revoke.sgml.diff?r1=1.31&r2=1.32) pgsql/src/backend/catalog: namespace.c (r1.71 -> r1.72) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/namespace.c.diff?r1=1.71&r2=1.72) pg_namespace.c (r1.10 -> r1.11) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_namespace.c.diff?r1=1.10&r2=1.11) pgsql/src/backend/commands: indexcmds.c (r1.126 -> r1.127) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/indexcmds.c.diff?r1=1.126&r2=1.127) schemacmds.c (r1.25 -> r1.26) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/schemacmds.c.diff?r1=1.25&r2=1.26) tablecmds.c (r1.138 -> r1.139) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c.diff?r1=1.138&r2=1.139) tablespace.c (r1.13 -> r1.14) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablespace.c.diff?r1=1.13&r2=1.14) pgsql/src/backend/nodes: copyfuncs.c (r1.292 -> r1.293) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c.diff?r1=1.292&r2=1.293) equalfuncs.c (r1.231 -> r1.232) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c.diff?r1=1.231&r2=1.232) pgsql/src/backend/parser: gram.y (r2.478 -> r2.479) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.478&r2=2.479) pgsql/src/backend/utils/adt: ruleutils.c (r1.184 -> r1.185) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c.diff?r1=1.184&r2=1.185) pgsql/src/backend/utils/cache: lsyscache.c (r1.117 -> r1.118) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/lsyscache.c.diff?r1=1.117&r2=1.118) pgsql/src/backend/utils/misc: guc.c (r1.247 -> r1.248) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c.diff?r1=1.247&r2=1.248) postgresql.conf.sample (r1.133 -> r1.134) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample.diff?r1=1.133&r2=1.134) pgsql/src/bin/pg_dump: pg_dump.c (r1.390 -> r1.391) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c.diff?r1=1.390&r2=1.391) pg_dump.h (r1.112 -> r1.113) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.h.diff?r1=1.112&r2=1.113) pgsql/src/bin/psql: describe.c (r1.108 -> r1.109) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/describe.c.diff?r1=1.108&r2=1.109) tab-complete.c (r1.117 -> r1.118) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/tab-complete.c.diff?r1=1.117&r2=1.118) pgsql/src/include/catalog: catversion.h (r1.251 -> r1.252) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.251&r2=1.252) pg_namespace.h (r1.14 -> r1.15) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_namespace.h.diff?r1=1.14&r2=1.15) pgsql/src/include/commands: tablespace.h (r1.6 -> r1.7) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/tablespace.h.diff?r1=1.6&r2=1.7) pgsql/src/include/nodes: parsenodes.h (r1.269 -> r1.270) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h.diff?r1=1.269&r2=1.270) pgsql/src/include/utils: guc.h (r1.54 -> r1.55) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/guc.h.diff?r1=1.54&r2=1.55) lsyscache.h (r1.91 -> r1.92) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/lsyscache.h.diff?r1=1.91&r2=1.92) pgsql/src/interfaces/ecpg/preproc: preproc.y (r1.299 -> r1.300) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/preproc/preproc.y.diff?r1=1.299&r2=1.300) pgsql/src/test/regress/input: tablespace.source (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/input/tablespace.source.diff?r1=1.1&r2=1.2) pgsql/src/test/regress/output: tablespace.source (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/output/tablespace.source.diff?r1=1.1&r2=1.2)
pgsql-committers by date: