]> granicus.if.org Git - postgresql/commit
Replace functional-index facility with expressional indexes. Any column
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 28 May 2003 16:04:02 +0000 (16:04 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 28 May 2003 16:04:02 +0000 (16:04 +0000)
commitfc8d970cbcdd6f025475822a4cf01dfda0873226
treeca697026dbada6a022dec471191aab5a0ba7eb20
parente5f19598e07e9a0fc0a5c0f18bfac1fe92d21fc5
Replace functional-index facility with expressional indexes.  Any column
of an index can now be a computed expression instead of a simple variable.
Restrictions on expressions are the same as for predicates (only immutable
functions, no sub-selects).  This fixes problems recently introduced with
inlining SQL functions, because the inlining transformation is applied to
both expression trees so the planner can still match them up.  Along the
way, improve efficiency of handling index predicates (both predicates and
index expressions are now cached by the relcache) and fix 7.3 oversight
that didn't record dependencies of predicate expressions.
50 files changed:
contrib/dblink/dblink.c
doc/src/sgml/catalogs.sgml
doc/src/sgml/indices.sgml
doc/src/sgml/plpgsql.sgml
doc/src/sgml/ref/create_index.sgml
doc/src/sgml/release.sgml
src/backend/bootstrap/bootparse.y
src/backend/bootstrap/bootstrap.c
src/backend/catalog/dependency.c
src/backend/catalog/heap.c
src/backend/catalog/index.c
src/backend/catalog/indexing.c
src/backend/catalog/pg_constraint.c
src/backend/commands/cluster.c
src/backend/commands/indexcmds.c
src/backend/commands/tablecmds.c
src/backend/commands/vacuum.c
src/backend/executor/execUtils.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/outfuncs.c
src/backend/optimizer/path/indxpath.c
src/backend/optimizer/path/pathkeys.c
src/backend/optimizer/plan/createplan.c
src/backend/optimizer/util/clauses.c
src/backend/optimizer/util/plancat.c
src/backend/parser/analyze.c
src/backend/parser/gram.y
src/backend/tcop/pquery.c
src/backend/utils/adt/ruleutils.c
src/backend/utils/adt/selfuncs.c
src/backend/utils/cache/relcache.c
src/bin/psql/describe.c
src/include/catalog/catversion.h
src/include/catalog/dependency.h
src/include/catalog/index.h
src/include/catalog/pg_index.h
src/include/catalog/pg_opclass.h
src/include/nodes/execnodes.h
src/include/nodes/parsenodes.h
src/include/nodes/relation.h
src/include/optimizer/clauses.h
src/include/utils/rel.h
src/include/utils/relcache.h
src/interfaces/python/tutorial/syscat.py
src/test/regress/expected/create_index.out
src/test/regress/expected/sanity_check.out
src/test/regress/sql/create_index.sql
src/test/regress/sql/sanity_check.sql
src/tutorial/syscat.source