Add CREATE OR REPLACE FUNCTION syntax to allow replacing a function
Tom Lane <tgl@sss.pgh.pa.us>
Add CREATE OR REPLACE FUNCTION syntax to allow replacing a function definition without changing the function's OID, thereby not breaking rules, views, triggers, etc that depend on it. From Gavin Sherry.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/create_function.sgml | modified | +28 −8 |
| src/backend/catalog/pg_proc.c | modified | +50 −17 |
| src/backend/commands/define.c | modified | +2 −1 |
| src/backend/nodes/copyfuncs.c | modified | +2 −1 |
| src/backend/nodes/equalfuncs.c | modified | +3 −1 |
| src/backend/parser/gram.y | modified | +19 −19 |
| src/backend/parser/keywords.c | modified | +2 −1 |
| src/backend/utils/adt/sets.c | modified | +2 −1 |
| src/include/catalog/pg_proc.h | modified | +2 −1 |
| src/include/nodes/parsenodes.h | modified | +2 −1 |
| src/interfaces/ecpg/preproc/keywords.c | modified | +4 −2 |
| src/interfaces/ecpg/preproc/preproc.y | modified | +14 −15 |