Postgres Pro
Downloads
Home   >   mailing lists

Re: SHA-1 vs MD5 - Mailing list pgsql-sql

From Chad Wagner
Subject Re: SHA-1 vs MD5
Date
Msg-id 81961ff50703090514k562d1218rd44df84a13d69507@mail.gmail.com
Whole thread Raw
In response to Re: SHA-1 vs MD5  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
Responses Re: SHA-1 vs MD5  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
List pgsql-sql
Tree view
On 3/9/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.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.

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Table inherit & foreign key problem
Next
From: "Shavonne Marietta Wijesinghe"
Date:
Subject: CREATE TABLE