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

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

From: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
To: "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com>
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 19:44:09
Message-ID: a8976915bb8aca74afcf3e2090040e3b.squirrel@webmail.harte-lyne.ca (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, February 28, 2012 14:03, Adrian Klaver wrote:

>>
>
> The PgAdmin folks would be better able to help you with
> the exact reason
> for the above, but I suspect they really meant:
>
> http://www.postgresql.org/docs/9.1/interactive/sql-alterlanguage.html
>
> ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO new_owner
>
> So in the category I have learned something new:
>
> template1=# \dL
>        List of languages
>    Name   |  Owner   | Trusted
> ---------+----------+---------
>   plpgsql | postgres | t
> (1 row)
>
> template1=# ALTER LANGUAGE plpgsql owner to aklaver;
> ALTER LANGUAGE
> template1=# \dL
>        List of languages
>    Name   |  Owner  | Trusted
> ---------+---------+---------
>   plpgsql | aklaver | t
> (1 row)
>

I encountered a strange inconsistency with PGAdmin3-1.14.2
relating to this.  After executing "ALTER LANGUAGE plpgsql
owner to devl;" in the SQL query pane inside PGAdmin3 the
extension ownership change is never reflected in the
object properties pane.  Even when disconnecting and
reconnecting to the server after the change the properties
pane of the extension in that database continues to show
the plpgsql owner as postgres.  psql on the other hand
shows the new language owner as expected.

By the way.  Thank you very much for your assistance with
this. It is greatly appreciated.

Regards,

-- 
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3


In response to

Responses

pgsql-general by date

Next:From: James B. ByrneDate: 2012-02-28 19:49:01
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1
Previous:From: Andy ColsonDate: 2012-02-28 19:24:35
Subject: Re: version controlling postgresql code

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