]> granicus.if.org Git - postgresql/commit
Disallow extensions from owning the schema they are assigned to.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Aug 2012 15:27:06 +0000 (11:27 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Aug 2012 15:27:06 +0000 (11:27 -0400)
commit9e035184b0fc807297dee5e2d0a219fee21fd08a
tree522c50fd78925ccbd00a986d613bf96fa72ac1e1
parent04e96bc69d541dd7b5f4d3b3daf49d291c7fcbb4
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