Re: SHA-1 vs MD5

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 <chad(dot)wagner(at)gmail(dot)com>:
>
> On 3/9/07, Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com> 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/