pgsql/ ontrib/chkpass/chkpass.sql ontrib/findo ...

CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: tgl(at)hub(dot)org 01/08/10 14:57:42

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

Log message:
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.