Re: erroneous restore into pg_catalog schema - Mailing list pgsql-hackers

From Greg Stark
Subject Re: erroneous restore into pg_catalog schema
Date
Msg-id CAM-w4HMDRGEp46wvCDQRXLwPE5kRZ1W4AdhLg+YLg8FsuKkAbw@mail.gmail.com
Whole thread Raw
In response to Re: erroneous restore into pg_catalog schema  (Stephen Frost <sfrost@snowman.net>)
Responses Re: erroneous restore into pg_catalog schema
List pgsql-hackers
On Mon, Jun 10, 2013 at 2:03 PM, Stephen Frost <sfrost@snowman.net> wrote:
> Having a schema that isn't pg_catalog doesn't necessairly mean we need a
> schema per extension.  Just a 'pg_extensions' schema, which is added to
> search_path behind the scenes (just like pg_catalog..) would be better
> than having everything go into pg_catalog.

Well no objection here. That's just like having /usr/local/{lib,bin,etc}.

> I'd prefer that we let the
> admins control both where extensions get installed to and what schemas
> are added to the end of the search_path.

This I object to. That's like having /usr/local/{apache,pgsql,kde,gnome}/bin.




-- 
greg



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: erroneous restore into pg_catalog schema
Next
From: "MauMau"
Date:
Subject: Re: Hard limit on WAL space used (because PANIC sucks)