Thread: pgsql-server/ ontrib/dblink/dblink.c oc/src/sg ...
pgsql-server/ ontrib/dblink/dblink.c oc/src/sg ...
From
tgl@developer.postgresql.org (Tom Lane)
Date:
CVSROOT: /cvsroot Module name: pgsql-server Changes by: tgl@developer.postgresql.org 03/05/28 12:04:02 Modified files: contrib/dblink : dblink.c doc/src/sgml : catalogs.sgml indices.sgml plpgsql.sgml release.sgml doc/src/sgml/ref: create_index.sgml src/backend/bootstrap: bootparse.y bootstrap.c src/backend/catalog: dependency.c heap.c index.c indexing.c pg_constraint.c src/backend/commands: cluster.c indexcmds.c tablecmds.c vacuum.c src/backend/executor: execUtils.c src/backend/nodes: copyfuncs.c equalfuncs.c outfuncs.c src/backend/optimizer/path: indxpath.c pathkeys.c src/backend/optimizer/plan: createplan.c src/backend/optimizer/util: clauses.c plancat.c src/backend/parser: analyze.c gram.y src/backend/tcop: pquery.c src/backend/utils/adt: ruleutils.c selfuncs.c src/backend/utils/cache: relcache.c src/bin/psql : describe.c src/include/catalog: catversion.h dependency.h index.h pg_index.h pg_opclass.h src/include/nodes: execnodes.h parsenodes.h relation.h src/include/optimizer: clauses.h src/include/utils: rel.h relcache.h src/interfaces/python/tutorial: syscat.py src/test/regress/expected: create_index.out sanity_check.out src/test/regress/sql: create_index.sql sanity_check.sql src/tutorial : syscat.source Log message: 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.