Postgres Pro
Downloads
Home   >   mailing lists

Re: How to inherit search_path from template - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How to inherit search_path from template
Date
Msg-id AANLkTinFqYf0J09CVV13mgNKAzje3PghwFoi6n1LOtp-@mail.gmail.com
Whole thread Raw
In response to Re: How to inherit search_path from template  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: How to inherit search_path from template
List pgsql-general
Tree view 
On Thu, Sep 9, 2010 at 7:41 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> On Thu, Sep 9, 2010 at 7:13 AM, Phui Hock <phuihock@gmail.com> wrote:
>> Hi,
>> How can I create a database template with altered search_path to be
>> inherited by child databases? Say, I created a template named
>> template_a with the following commands:
>
> It doesn't really work that way -- GUC values are global,  not per
> database.

You can do "alter database xyz set search_path=..."

pgsql-general by date:

Previous
From: sunpeng
Date:
Subject: why can't see the updated value after SPI_execute("update ....", false, 1);
Next
From: Craig Ringer
Date:
Subject: Re: Huge amount of memory errors with libpq