Re: How to install PGCRYPTO in PostgreSQL9

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