]> granicus.if.org Git - postgresql/commit
Allow non-superuser database owners to create procedural languages.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 26 Mar 2007 16:58:41 +0000 (16:58 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 26 Mar 2007 16:58:41 +0000 (16:58 +0000)
commit55a7cf80a0769d38f03bd728717da855902041b1
tree147a3aa02b95844de61c869232c2dbe802914e67
parent66daeb074b3fbdb071a5631c066f5e41d554220e
Allow non-superuser database owners to create procedural languages.
A DBA is allowed to create a language in his database if it's marked
"tmpldbacreate" in pg_pltemplate.  The factory default is that this is set
for all standard trusted languages, but of course a superuser may adjust
the settings.  In service of this, add the long-foreseen owner column to
pg_language; renaming, dropping, and altering owner of a PL now follow
normal ownership rules instead of being superuser-only.
Jeremy Drake, with some editorialization by Tom Lane.
17 files changed:
doc/src/sgml/catalogs.sgml
doc/src/sgml/ref/alter_language.sgml
doc/src/sgml/ref/create_language.sgml
doc/src/sgml/ref/drop_language.sgml
src/backend/catalog/aclchk.c
src/backend/commands/alter.c
src/backend/commands/proclang.c
src/backend/parser/gram.y
src/backend/tcop/utility.c
src/bin/pg_dump/pg_backup_archiver.c
src/bin/pg_dump/pg_dump.c
src/bin/psql/tab-complete.c
src/include/catalog/catversion.h
src/include/catalog/pg_language.h
src/include/catalog/pg_pltemplate.h
src/include/commands/proclang.h
src/include/utils/acl.h