Skip site navigation (1) Skip section navigation (2)

pgsql: Disallow extensions from owning the schema they are assignedto.

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 assignedto.
Date: 2012-08-15 15:28:15
Message-ID: E1T1fW3-0001tQ-E1@gemulon.postgresql.org (view raw or flat)
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
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4d642b59417d5d4a62d126ca12a80da45d2a3fbf

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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group