Re: How to install PGCRYPTO in PostgreSQL9

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Andre Lopes <lopes80andre(at)gmail(dot)com>, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Subject: Re: How to install PGCRYPTO in PostgreSQL9
Date: 2011-08-17 13:59:55
Message-ID: 201108170659.55659.adrian.klaver@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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(at)andre public]$
> [/code]
>
> What's wrong here?

Would seem to indicate you did not install as database superuser.

>

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Murat Kabilov 2011-08-17 14:01:18 Stored procedure name
Previous Message Andre Lopes 2011-08-17 13:44:31 Re: How to install PGCRYPTO in PostgreSQL9