Partial indexes work again, courtesy of Martijn van Oosterhout.

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

Commit: f31dc0ada731d89313dbca7ef5da91d674fc640c
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2001-07-16T05:07:00Z
Releases: 7.2.1
Partial indexes work again, courtesy of Martijn van Oosterhout.
Note: I didn't force an initdb, figuring that one today was enough.
However, there is a new function in pg_proc.h, and pg_dump won't be
able to dump partial indexes until you add that function.

Files

PathChange+/−
doc/src/sgml/indices.sgml modified +2 −13
doc/src/sgml/ref/create_index.sgml modified +61 −14
src/backend/bootstrap/bootstrap.c modified +4 −3
src/backend/catalog/index.c modified +8 −89
src/backend/commands/command.c modified +2 −2
src/backend/commands/indexcmds.c modified +19 −150
src/backend/executor/execUtils.c modified +4 −4
src/backend/optimizer/path/indxpath.c modified +38 −29
src/backend/optimizer/util/pathnode.c modified +8 −1
src/backend/parser/analyze.c modified +17 −31
src/backend/parser/gram.y modified +8 −26
src/backend/parser/keywords.c modified +1 −2
src/backend/tcop/utility.c modified +1 −13
src/backend/utils/adt/ruleutils.c modified +60 −1
src/backend/utils/adt/selfuncs.c modified +50 −10
src/bin/pg_dump/pg_dump.c modified +43 −6
src/bin/pg_dump/pg_dump.h modified +2 −1
src/include/catalog/index.h modified +1 −3
src/include/catalog/pg_proc.h modified +4 −1
src/include/commands/defrem.h modified +2 −5
src/include/config.h.in modified +1 −2
src/include/nodes/execnodes.h modified +3 −3
src/include/utils/builtins.h modified +2 −1
src/interfaces/ecpg/preproc/keywords.c modified +2 −2
src/interfaces/ecpg/preproc/preproc.y modified +22 −30
src/test/regress/expected/create_index.out modified +6 −9
src/test/regress/expected/portals_p2.out modified +0 −1
src/test/regress/expected/sanity_check.out modified +2 −1
src/test/regress/expected/select.out modified +74 −10
src/test/regress/sql/create_index.sql modified +6 −11
src/test/regress/sql/portals_p2.sql modified +0 −2
src/test/regress/sql/select.sql modified +16 −10