]> 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:26:55 +0000 (11:26 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Aug 2012 15:28:03 +0000 (11:28 -0400)
commit4d642b59417d5d4a62d126ca12a80da45d2a3fbf
tree3becb737a17f5a65a5696cd663887a356524380b
parenta973296598f2d1eec48138a2ce4f3e63410d9ed0
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