Skip site navigation (1) Skip section navigation (2)

Pgcrypto install (I've tried multiple ways)

From: "David Patricola" <david(dot)patricola(at)jefferson(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Pgcrypto install (I've tried multiple ways)
Date: 2011-01-27 21:31:01
Message-ID: E26DCD30A98C4F3CAE76C63071D97AF0@tjumst.jefferson.edu (view raw or flat)
Thread:
Lists: pgsql-novice
I'm not sure what I'm doing wrong here.  I've tried to install the pgcrypto
module from:

 

1.	psql shell: i\ path/to/pgcrypto.sql
2.	pgAdmin: execute pgScript pgcrypto.sql

 

Both showed me multiple lines of CREATE FUNCTION with no other errors.
However, when I try to test the decrypt() function it says it doesn't exist.
Encrypt() has worked fine, even before the module install.  Stopping and
starting the service doesn't help.

 

I'm running pgAdmin 1.12 with Postgresql 9.0 installed on Windows 2003.

 

David Patricola | Senior Cold Fusion Developer | Web Applications & Services
| Jefferson Information Technologies

 

Thomas Jefferson Universtiy | Philadelphia, PA | 215.503.1715 (Office)

 

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2011-01-27 21:44:42
Subject: Re: Pgcrypto install (I've tried multiple ways)
Previous:From: Josh KupershmidtDate: 2011-01-27 04:10:34
Subject: Re: new to postgreSql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group