Re: How to install PGCRYPTO in PostgreSQL9 - Mailing list pgsql-general

From Andre Lopes
Subject Re: How to install PGCRYPTO in PostgreSQL9
Date
Msg-id CAGFRAbNsA5b_YwFE_78BpnS209c1_QuT42wZnp0yya9OWgt=bg@mail.gmail.com
Whole thread Raw
In response to Re: How to install PGCRYPTO in PostgreSQL9  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Thanks for the reply. I have installed with the user "postgres" and it
worked. Thanks!


2011/8/17 Adrian Klaver <adrian.klaver@gmail.com>:
> On Wednesday, August 17, 2011 6:44:31 am Andre Lopes wrote:
>> I have installed and tried to import the SQL, but I got this:
>>
>> [code]
>> [andre@andre public]$ psql -d 420 -f
>> /usr/pgsql-9.0/share/contrib/pgcrypto.sql SET
>
>> psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:197: ERROR:  permission
>> denied for language c
>> psql:/usr/pgsql-9.0/share/contrib/pgcrypto.sql:202: ERROR:  permission
>> denied for language c
>> [andre@andre public]$
>> [/code]
>>
>> What's wrong here?
>
> Would seem to indicate you did not install as database superuser.
>
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com
>

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to install PGCRYPTO in PostgreSQL9
Next
From: Murat Kabilov
Date:
Subject: Stored procedure name