You are correct. My pg (8.1.3)
Now what I do to remove it ?
Just delete the functions ?
Ezequias
2007/3/9, Chad Wagner <[EMAIL PROTECTED]>:
On 3/9/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
>
> Thank you so much for your information. I installed the pgCrypto. Now I
> have more than 40 functions (i believe all are from pgcrypto) but when I try
> to run your query:
>
> select encode(digest('blahblah', 'sha256'), 'hex');
>
> I got the error:
>
> ERROR: Cannot use "sha256": No such hash algorithm
> SQL state: 22023
>
It may not be available in your version of the database/pgcrypto module,
my test was performed on 8.2.3.
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/
