Re: How to inherit search_path from template

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Phui Hock <phuihock(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to inherit search_path from template
Date: 2010-09-12 12:34:23
Message-ID: AANLkTinFqYf0J09CVV13mgNKAzje3PghwFoi6n1LOtp-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 9, 2010 at 7:41 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Thu, Sep 9, 2010 at 7:13 AM, Phui Hock <phuihock(at)gmail(dot)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=..."

In response to

Responses

Browse pgsql-general by date

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