pgsql: Create 'default_tablespace' GUC variable that supplies a

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create 'default_tablespace' GUC variable that supplies a
Date: 2004-11-05 19:17:31
Message-ID: 20041105191731.9569D3A3E49@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-committers by date

  From Date Subject
Next Message User Mha 2004-11-05 19:35:40 pginstaller - pginst: Properly quote passwords with spaces in them per
Previous Message User Mha 2004-11-05 19:11:29 pginstaller - pginst: Add icons to buttons in directory browse dialog,