Commit of a *MAJOR* patch from Dan McGuirk <djm@indirect.com>

Marc G. Fournier <scrappy@hub.org>

Commit: 07a65b22554d54455de5bc791a48fb0542f48791
Author: Marc G. Fournier <scrappy@hub.org>
Date: 1996-11-13T20:56:15Z
Releases: 7.1.1
Commit of a *MAJOR* patch from Dan McGuirk <djm@indirect.com>

Changes:

        * Unique index capability works using the syntax 'create unique
          index'.

        * Duplicate OID's in the system tables are removed.  I put
          little scripts called 'duplicate_oids' and 'find_oid' in
          include/catalog that help to find and remove duplicate OID's.
          I also moved 'unused_oids' from backend/catalog to
          include/catalog, since it has to be in the same directory
          as the include files in order to work.

        * The backend tries converting the name of a function or aggregate
          to all lowercase if the original name given doesn't work (mostly
          for compatibility with ODBC).

        * You can 'SELECT NULL' to your heart's content.

        * I put my _bt_updateitem fix in instead, which uses
          _bt_insertonpg so that even if the new key is so big that
          the page has to be split, everything still works.

        * All literal references to system catalog OID's have been
          replaced with references to define'd constants from the catalog
          header files.

        * I added a couple of node copy functions.  I think this was a
          preliminary attempt to get rules to work.

Files

PathChange+/−
src/backend/access/gist/gist.c modified +1 −1
src/backend/access/hash/hash.c modified +2 −2
src/backend/access/index/indexam.c modified +4 −3
src/backend/access/nbtree/nbtinsert.c modified +102 −45
src/backend/access/nbtree/nbtree.c modified +10 −4
src/backend/access/nbtree/nbtsearch.c modified +3 −3
src/backend/access/rtree/rtree.c modified +2 −2
src/backend/bootstrap/bootparse.y modified +2 −2
src/backend/catalog/index.c modified +75 −6
src/backend/catalog/indexing.c modified +2 −2
src/backend/catalog/unused_oids modified +0 −41
src/backend/commands/cluster.c modified +4 −2
src/backend/commands/copy.c modified +2 −2
src/backend/commands/defind.c modified +4 −3
src/backend/executor/execMain.c modified +4 −3
src/backend/executor/execUtils.c modified +5 −4
src/backend/nodes/copyfuncs.c modified +42 −2
src/backend/parser/analyze.c modified +49 −1
src/backend/parser/catalog_utils.c modified +47 −1
src/backend/parser/gram.y modified +19 −13
src/backend/parser/keywords.c modified +2 −1
src/backend/parser/parse_query.c modified +4 −2
src/backend/parser/parser.c modified +14 −14
src/backend/storage/large_object/inv_api.c modified +3 −3
src/backend/storage/page/bufpage.c modified +7 −3
src/backend/tcop/utility.c modified +2 −1
src/backend/utils/cache/catcache.c modified +2 −1
src/include/access/genam.h modified +3 −2
src/include/access/gist.h modified +1 −1
src/include/access/hash.h modified +2 −2
src/include/access/nbtree.h modified +7 −3
src/include/access/rtree.h modified +2 −2
src/include/catalog/index.h modified +6 −2
src/include/catalog/pg_amop.h modified +4 −4
src/include/catalog/pg_amproc.h modified +4 −4
src/include/catalog/pg_attribute.h modified +286 −286
src/include/catalog/pg_class.h modified +33 −32
src/include/catalog/pg_index.h modified +15 −7
src/include/catalog/pg_operator.h modified +6 −6
src/include/catalog/pg_parg.h modified +6 −5
src/include/catalog/pg_proc.h modified +42 −42
src/include/catalog/pg_type.h modified +22 −17
src/include/commands/defrem.h modified +4 −2
src/include/executor/executor.h modified +2 −2
src/include/nodes/parsenodes.h modified +3 −2