OSDN Git Service

Make OIDs optional, per discussions in pghackers. WITH OIDS is still the
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 10 Aug 2001 18:57:42 +0000 (18:57 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 10 Aug 2001 18:57:42 +0000 (18:57 +0000)
commitbf56f0759bdfa87f143c3abd09f893a5f530fe88
tree10555a5e46bcfdfd9799b8f0e13ab48101d766de
parentd062f0f4e91f68b1f55b04691bd92d1efc83dc54
Make OIDs optional, per discussions in pghackers.  WITH OIDS is still the
default, but OIDS are removed from many system catalogs that don't need them.
Some interesting side effects: TOAST pointers are 20 bytes not 32 now;
pg_description has a three-column key instead of one.

Bugs fixed in passing: BINARY cursors work again; pg_class.relhaspkey
has some usefulness; pg_dump dumps comments on indexes, rules, and
triggers in a valid order.

initdb forced.
83 files changed:
contrib/chkpass/chkpass.sql
contrib/findoidjoins/README.findoidjoins
contrib/findoidjoins/findoidjoins.c
contrib/findoidjoins/make_oidjoins_check
contrib/intarray/_int.sql.in
doc/src/sgml/catalogs.sgml
doc/src/sgml/ref/create_table.sgml
doc/src/sgml/syntax.sgml
src/backend/access/heap/heapam.c
src/backend/access/heap/tuptoaster.c
src/backend/access/transam/varsup.c
src/backend/access/transam/xlog.c
src/backend/bootstrap/bootparse.y
src/backend/bootstrap/bootscanner.l
src/backend/bootstrap/bootstrap.c
src/backend/catalog/catalog.c
src/backend/catalog/genbki.sh
src/backend/catalog/heap.c
src/backend/catalog/index.c
src/backend/catalog/indexing.c
src/backend/commands/cluster.c
src/backend/commands/command.c
src/backend/commands/comment.c
src/backend/commands/copy.c
src/backend/commands/creatinh.c
src/backend/commands/dbcommands.c
src/backend/commands/indexcmds.c
src/backend/commands/remove.c
src/backend/commands/sequence.c
src/backend/commands/trigger.c
src/backend/commands/vacuum.c
src/backend/commands/vacuumlazy.c
src/backend/commands/view.c
src/backend/executor/execMain.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/outfuncs.c
src/backend/parser/gram.y
src/backend/parser/parse_relation.c
src/backend/rewrite/rewriteRemove.c
src/backend/utils/cache/relcache.c
src/backend/utils/cache/syscache.c
src/bin/initdb/initdb.sh
src/bin/pg_dump/pg_dump.c
src/bin/pg_dump/pg_dump.h
src/bin/psql/describe.c
src/bin/psql/large_obj.c
src/include/access/transam.h
src/include/bootstrap/bootstrap.h
src/include/catalog/catversion.h
src/include/catalog/heap.h
src/include/catalog/index.h
src/include/catalog/indexing.h
src/include/catalog/pg_amop.h
src/include/catalog/pg_amproc.h
src/include/catalog/pg_attrdef.h
src/include/catalog/pg_attribute.h
src/include/catalog/pg_class.h
src/include/catalog/pg_description.h
src/include/catalog/pg_group.h
src/include/catalog/pg_index.h
src/include/catalog/pg_inherits.h
src/include/catalog/pg_largeobject.h
src/include/catalog/pg_listener.h
src/include/catalog/pg_log.h
src/include/catalog/pg_proc.h
src/include/catalog/pg_relcheck.h
src/include/catalog/pg_shadow.h
src/include/catalog/pg_statistic.h
src/include/catalog/unused_oids
src/include/commands/comment.h
src/include/nodes/parsenodes.h
src/include/parser/parse_relation.h
src/include/postgres.h
src/include/utils/syscache.h
src/interfaces/ecpg/preproc/preproc.y
src/test/regress/expected/oidjoins.out
src/test/regress/expected/opr_sanity.out
src/test/regress/expected/rules.out
src/test/regress/expected/type_sanity.out
src/test/regress/sql/oidjoins.sql
src/test/regress/sql/opr_sanity.sql
src/test/regress/sql/type_sanity.sql