| From: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
| Subject: | Re: How to install PGCRYPTO in PostgreSQL9 |
| Date: | 2011-08-17 14:06:30 |
| Message-ID: | CAGFRAbNsA5b_YwFE_78BpnS209c1_QuT42wZnp0yya9OWgt=bg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks for the reply. I have installed with the user "postgres" and it
worked. Thanks!
2011/8/17 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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(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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2011-08-17 14:32:23 | Re: Using Postgresql as application server |
| Previous Message | Murat Kabilov | 2011-08-17 14:01:18 | Stored procedure name |