Allow ALTER FUNCTION to change a function's strictness, volatility, and
authorNeil Conway <[email protected]>
Mon, 14 Mar 2005 00:19:37 +0000 (00:19 +0000)
committerNeil Conway <[email protected]>
Mon, 14 Mar 2005 00:19:37 +0000 (00:19 +0000)
commitc06965544188244efa703f6a97f3088a291d57b5
tree3bb6f3068d418b4ef98828db4f856e852c02df20
parent41e2a80f570bf0e8e68d0eef7d1510e5ec32b3ae
Allow ALTER FUNCTION to change a function's strictness, volatility, and
whether or not it is a security definer. Changing a function's strictness
is required by SQL2003, and the other capabilities make sense. Also, allow
an optional RESTRICT noise word to be specified, for SQL conformance.

Some trivial regression tests added and the documentation has been
updated.
12 files changed:
doc/src/sgml/ref/alter_function.sgml
doc/src/sgml/ref/alter_index.sgml
src/backend/commands/functioncmds.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/backend/tcop/utility.c
src/include/commands/defrem.h
src/include/nodes/nodes.h
src/include/nodes/parsenodes.h
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql