pgsql: Disallow extensions from owning the schema they are assigned to.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Disallow extensions from owning the schema they are assigned to.
Date: 2012-08-15 15:28:15
Message-ID: E1T1fW3-0001tT-Fx@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Branch
------
REL9_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/82634a88d1ba2fdc3308d589b0b8f3bfdbd880f1

Modified Files
--------------
src/backend/commands/extension.c | 30 +++++++++++++++++++++++++++---
1 files changed, 27 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Geoghegan 2012-08-15 15:41:38 Re: [COMMITTERS] pgsql: Revert "commit_delay" change; just add comment that we don't hav
Previous Message Bruce Momjian 2012-08-15 15:23:17 pgsql: Properly escape usernames in initdb, so names with single-quotes