Allow ALTER FUNCTION to change a function's strictness, volatility, and
Neil Conway <neilc@samurai.com>
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.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/alter_function.sgml | modified | +74 −9 |
| doc/src/sgml/ref/alter_index.sgml | modified | +3 −5 |
| src/backend/commands/functioncmds.c | modified | +141 −40 |
| src/backend/nodes/copyfuncs.c | modified | +15 −1 |
| src/backend/nodes/equalfuncs.c | modified | +13 −1 |
| src/backend/parser/gram.y | modified | +63 −21 |
| src/backend/tcop/utility.c | modified | +11 −1 |
| src/include/commands/defrem.h | modified | +2 −1 |
| src/include/nodes/nodes.h | modified | +2 −1 |
| src/include/nodes/parsenodes.h | modified | +8 −1 |
| src/test/regress/expected/alter_table.out | modified | +35 −0 |
| src/test/regress/sql/alter_table.sql | modified | +17 −0 |