Horton

Tablespaces. Alternate database locations are dead, long live tablespaces.

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

View on postgr.es
Commit: 2467394ee1566e82d0314d12a0d1c0a5670a28c9
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2004-06-18T06:14:31Z
Releases: 8.0.0 
Tablespaces.  Alternate database locations are dead, long live tablespaces.

There are various things left to do: contrib dbsize and oid2name modules
need work, and so does the documentation.  Also someone should think about
COMMENT ON TABLESPACE and maybe RENAME TABLESPACE.  Also initlocation is
dead, it just doesn't know it yet.

Gavin Sherry and Tom Lane.

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +103 −7
doc/src/sgml/manage-ag.sgml modified +6 −16
doc/src/sgml/ref/allfiles.sgml modified +3 −1
doc/src/sgml/ref/create_database.sgml modified +25 −79
doc/src/sgml/ref/create_index.sgml modified +31 −19
doc/src/sgml/ref/create_schema.sgml modified +26 −12
doc/src/sgml/ref/create_sequence.sgml modified +17 −3
doc/src/sgml/ref/create_table.sgml modified +43 −20
doc/src/sgml/ref/create_tablespace.sgml added +156 −0
doc/src/sgml/ref/drop_tablespace.sgml added +103 −0
doc/src/sgml/reference.sgml modified +3 −1
doc/src/sgml/ref/grant.sgml modified +15 −5
doc/src/sgml/ref/psql-ref.sgml modified +715 −702
doc/src/sgml/ref/revoke.sgml modified +7 −1
src/backend/access/heap/heapam.c modified +6 −5
src/backend/access/nbtree/nbtxlog.c modified +15 −12
src/backend/access/transam/xlogutils.c modified +2 −2
src/backend/bootstrap/bootparse.y modified +6 −1
src/backend/catalog/aclchk.c modified +296 −5
src/backend/catalog/catalog.c modified +48 −14
src/backend/catalog/heap.c modified +20 −12
src/backend/catalog/index.c modified +3 −1
src/backend/catalog/Makefile modified +3 −3
src/backend/catalog/namespace.c modified +2 −2
src/backend/catalog/pg_namespace.c modified +3 −2
src/backend/commands/cluster.c modified +2 −1
src/backend/commands/dbcommands.c modified +174 −252
src/backend/commands/indexcmds.c modified +30 −2
src/backend/commands/Makefile modified +3 −3
src/backend/commands/schemacmds.c modified +29 −2
src/backend/commands/sequence.c modified +6 −5
src/backend/commands/tablecmds.c modified +40 −8
src/backend/commands/tablespace.c added +660 −0
src/backend/commands/typecmds.c modified +4 −3
src/backend/commands/view.c modified +4 −3
src/backend/executor/execMain.c modified +2 −1
src/backend/nodes/copyfuncs.c modified +33 −1
src/backend/nodes/equalfuncs.c modified +29 −1
src/backend/nodes/outfuncs.c modified +5 −3
src/backend/parser/analyze.c modified +3 −1
src/backend/parser/gram.y modified +90 −20
src/backend/parser/keywords.c modified +2 −1
src/backend/storage/buffer/bufmgr.c modified +37 −36
src/backend/storage/buffer/localbuf.c modified +4 −4
src/backend/storage/freespace/freespace.c modified +5 −7
src/backend/storage/smgr/md.c modified +10 −7
src/backend/storage/smgr/smgr.c modified +37 −26
src/backend/tcop/utility.c modified +24 −1
src/backend/utils/adt/acl.c modified +5 −1
src/backend/utils/adt/ruleutils.c modified +19 −1
src/backend/utils/cache/inval.c modified +18 −9
src/backend/utils/cache/lsyscache.c modified +57 −1
src/backend/utils/cache/relcache.c modified +45 −28
src/backend/utils/init/globals.c modified +3 −1
src/backend/utils/init/miscinit.c modified +2 −9
src/backend/utils/init/postinit.c modified +9 −8
src/backend/utils/misc/database.c modified +18 −20
src/bin/initdb/initdb.c modified +3 −3
src/bin/pg_dump/dumputils.c modified +7 −5
src/bin/pg_dump/pg_dumpall.c modified +92 −22
src/bin/pg_dump/pg_dump.c modified +116 −37
src/bin/pg_dump/pg_dump.h modified +3 −1
src/bin/psql/command.c modified +4 −1
src/bin/psql/describe.c modified +41 −2
src/bin/psql/describe.h modified +4 −1
src/bin/psql/help.c modified +3 −2
src/include/catalog/catalog.h modified +2 −2
src/include/catalog/catname.h modified +2 −1
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/heap.h modified +3 −1
src/include/catalog/index.h modified +2 −1
src/include/catalog/indexing.h modified +5 −1
src/include/catalog/pg_attribute.h modified +58 −40
src/include/catalog/pg_class.h modified +34 −29
src/include/catalog/pg_database.h modified +4 −4
src/include/catalog/pg_namespace.h modified +10 −7
src/include/catalog/pg_tablespace.h added +66 −0
src/include/catalog/pg_type.h modified +9 −8
src/include/commands/defrem.h modified +2 −1
src/include/commands/tablespace.h added +29 −0
src/include/miscadmin.h modified +4 −2
src/include/nodes/nodes.h modified +3 −1
src/include/nodes/parsenodes.h modified +28 −2
src/include/storage/buf_internals.h modified +3 −2
src/include/storage/relfilenode.h modified +47 −9
src/include/utils/acl.h modified +7 −1
src/include/utils/lsyscache.h modified +3 −1
src/include/utils/relcache.h modified +4 −3
src/test/regress/expected/sanity_check.out modified +2 −1
src/test/regress/GNUmakefile modified +10 −2
src/test/regress/input/tablespace.source added +36 −0
src/test/regress/output/tablespace.source added +45 −0
src/test/regress/parallel_schedule modified +4 −1
src/test/regress/serial_schedule modified +2 −1