]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Disallow extensions from owning the schema they are assigned to.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Aug 2012 15:27:00 +0000 (11:27 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Aug 2012 15:27:00 +0000 (11:27 -0400)
commit82634a88d1ba2fdc3308d589b0b8f3bfdbd880f1
tree7c5ef6a6c964634d0546439ef522e4c9f35bb410
parent43ccd309cbf4e9b09ac59130c9b31a1c58a9ff2d
Disallow extensions from owning the schema they are assigned to.

This situation creates a dependency loop that confuses pg_dump and probably
other things.  Moreover, since the mental model is that the extension
"contains" schemas it owns, but "is contained in" its extschema (even
though neither is strictly true), having both true at once is confusing for
people too.  So prevent the situation from being set up.

Reported and patched by Thom Brown.  Back-patch to 9.1 where extensions
were added.
src/backend/commands/extension.c