aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/funcs.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2009-10-02 18:13:10 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2009-10-02 18:13:10 +0000
commitac317a8474e7c2e2c67ee37f8cb1a6511eb662d9 (patch)
treef1af22bc7761632a89f9cd2a6309a5886b01b360 /src/tutorial/funcs.c
parentae35363dced47a99178b4a4129e3ea1f990b829c (diff)
downloadpostgresql-ac317a8474e7c2e2c67ee37f8cb1a6511eb662d9.tar.gz
postgresql-ac317a8474e7c2e2c67ee37f8cb1a6511eb662d9.zip
Fix erroneous handling of shared dependencies (ie dependencies on roles)
in CREATE OR REPLACE FUNCTION. The original code would update pg_shdepend as if a new function was being created, even if it wasn't, with two bad consequences: pg_shdepend might record the wrong owner for the function, and any dependencies for roles mentioned in the function's ACL would be lost. The fix is very easy: just don't touch pg_shdepend at all when doing a function replacement. Also update the CREATE FUNCTION reference page, which never explained exactly what changes and doesn't change in a function replacement. In passing, fix the CREATE VIEW reference page similarly; there's no code bug there, but the docs didn't say what happens.
Diffstat (limited to 'src/tutorial/funcs.c')
0 files changed, 0 insertions, 0 deletions