Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx
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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux