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

Re: Having a problem with RoR-3.1.1 and Pg-9.1

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1
Date: 2012-02-28 18:28:30
Message-ID: 4F4D1CCE.4050706@gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On 02/28/2012 10:23 AM, James B. Byrne wrote:
>
> On Tue, February 28, 2012 12:17, Adrian Klaver wrote:
>
>>
>> I guess the options are either do as I did above or
>> create a new template database as the owner you want
>> and use that as the template for your CREATE
>> DATABASE.
>
>
> Why does this not work?
>
> =>  \c test
> You are now connected to database "test" as user "devl".
> ALTER EXTENSION plpgsql OWNER TO devl;
> ERROR:  syntax error at or near "OWNER"
> LINE 1: ALTER EXTENSION plpgsql OWNER TO devl;
> =>  \c - postgres
> You are now connected to database "test" as user "postgres".
> ALTER EXTENSION plpgsql OWNER TO devl;
> ERROR:  syntax error at or near "OWNER"
> LINE 1: ALTER EXTENSION plpgsql OWNER TO devl;
>

There is no OWNER clause in ALTER EXTENSION.
If you are trying to do what I showed, you need to as the'postgres' user 
DROP EXTENSION plpgsl in database 'test' and then become owner 'dev1' 
and CREATE EXTENSION plpgsl


-- 
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

pgsql-general by date

Next:From: akp geekDate: 2012-02-28 18:28:37
Subject: version controlling postgresql code
Previous:From: James B. ByrneDate: 2012-02-28 18:23:57
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1

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