Skip site navigation (1) Skip section navigation (2)

pgsql-server/ ontrib/dblink/dblink.c oc/src/sg ...

From: tgl(at)developer(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server/ ontrib/dblink/dblink.c oc/src/sg ...
Date: 2003-05-28 16:04:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
CVSROOT:	/cvsroot
Module name:	pgsql-server
Changes by:	tgl(at)developer(dot)postgresql(dot)org	03/05/28 12:04:02

Modified files:
	contrib/dblink : dblink.c 
	doc/src/sgml   : catalogs.sgml indices.sgml plpgsql.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 
	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/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.

pgsql-committers by date

Next:From: Tom LaneDate: 2003-05-28 17:25:02
Subject: pgsql-server/src backend/postmaster/postmaster ...
Previous:From: Bruce Momjian - CVSDate: 2003-05-28 05:02:38
Subject: pgsql-server/doc/TODO.detail thread

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group