I'm not sure what I'm doing wrong here. I've tried to install the pgcrypto
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)
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2011-01-27 21:44:42|
|Subject: Re: Pgcrypto install (I've tried multiple ways) |
|Previous:||From: Josh Kupershmidt||Date: 2011-01-27 04:10:34|
|Subject: Re: new to postgreSql|