Divide functions into three volatility classes (immutable, stable, and

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

Commit: 4bdb4be62e652ee3220dae21a4fa340832c93429

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

Date: 2002-04-05T00:31:36Z

Divide functions into three volatility classes (immutable, stable, and
volatile), rather than the old cachable/noncachable distinction.  This
allows indexscan optimizations in many places where we formerly didn't.
Also, add a pronamespace column to pg_proc (it doesn't do anything yet,
however).

Files

Path	Change	+/−
doc/src/sgml/catalogs.sgml	modified	+29 −8
doc/src/sgml/ref/create_function.sgml	modified	+49 −18
doc/src/sgml/release.sgml	modified	+2 −1
src/backend/catalog/indexing.c	modified	+2 −2
src/backend/catalog/pg_proc.c	modified	+29 −25
src/backend/commands/define.c	modified	+22 −16
src/backend/commands/indexcmds.c	modified	+8 −7
src/backend/optimizer/path/indxpath.c	modified	+5 −5
src/backend/optimizer/util/clauses.c	modified	+79 −27
src/backend/parser/parse_func.c	modified	+2 −2
src/backend/utils/adt/regproc.c	modified	+15 −49
src/backend/utils/adt/sets.c	modified	+2 −2
src/backend/utils/cache/lsyscache.c	modified	+12 −12
src/backend/utils/cache/syscache.c	modified	+2 −2
src/backend/utils/Gen_fmgrtab.sh	modified	+3 −3
src/bin/pg_dump/pg_dump.c	modified	+36 −10
src/bin/pg_dump/pg_dump.h	modified	+3 −3
src/include/catalog/catversion.h	modified	+2 −2
src/include/catalog/indexing.h	modified	+3 −3
src/include/catalog/pg_attribute.h	modified	+35 −33
src/include/catalog/pg_class.h	modified	+2 −2
src/include/catalog/pg_proc.h	modified	+1316 −1301
src/include/optimizer/clauses.h	modified	+3 −2
src/include/utils/lsyscache.h	modified	+3 −3
src/test/regress/expected/opr_sanity.out	modified	+1 −1
src/test/regress/sql/opr_sanity.sql	modified	+1 −1