Re: [SQL] SHA-1 vs MD5

2007-03-09 Thread Ezequias Rodrigues da Rocha
You are correct SH1 is supported. So I get the output size from 128 to 160 ok ? I saw at wikipedia. What does "With flaws" colisions means ? Does it means some ? in MD5 the put only "yes" Regards Ezequias 2007/3/9, Chad Wagner <[EMAIL PROTECTED]>: On 3/9/07, Ezequias Rodrigues da Rocha <[EMA

Re: [SQL] SHA-1 vs MD5

2007-03-09 Thread Chad Wagner
On 3/9/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: You are correct. My pg (8.1.3) Now what I do to remove it ? Just delete the functions ? There is usually an uninstall_pgcrypto.sql script you can run against the database. But 8.1 probably supports at least sha1, or you can

Re: [SQL] SHA-1 vs MD5

2007-03-09 Thread Ezequias Rodrigues da Rocha
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 mor

Re: [SQL] SHA-1 vs MD5

2007-03-09 Thread Chad Wagner
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 th

Re: [SQL] SHA-1 vs MD5

2007-03-09 Thread Ezequias Rodrigues da Rocha
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 sta

Re: [SQL] SHA-1 vs MD5

2007-03-08 Thread Chad Wagner
On 3/8/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: I really don't have the pgcrypto. It could be a nice alternative. Could you tell me the steps to install it ? This should help you out: http://www.postgresql.org/docs/8.2/static/external-extensions.html http://developer.postgr

Re: [SQL] SHA-1 vs MD5

2007-03-08 Thread Ezequias Rodrigues da Rocha
I really don't have the pgcrypto. It could be a nice alternative. Could you tell me the steps to install it ? I am very concerned about security in my application becouse we are going to moviment a large ammount of information and money. As much i take care of it as good. I know some problem of

Re: [SQL] SHA-1 vs MD5

2007-03-07 Thread Chad Wagner
On 3/7/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: I know that there is a md5 internal function on postgresql, but I noticed that it isn't the more secure today. I would like to know if there is a SHA-1 function implemented yet of, if not, if the team has plan to introduce it on P

Re: [SQL] SHA-1 vs MD5

2007-03-07 Thread Andrej Ricnik-Bay
On 3/8/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote: What is the problem you're trying to solve? Md5 is probably good enough for many cases, but for long-term use, you're right that sha-1 is what you need. Actually, you need sha-256, quite frankly. Looking at his last mail he's after a passwo

Re: [SQL] SHA-1 vs MD5

2007-03-07 Thread Andrew Sullivan
On Wed, Mar 07, 2007 at 05:04:18PM -0300, Ezequias Rodrigues da Rocha wrote: > Hi list, > > I know that there is a md5 internal function on postgresql, but I noticed > that it isn't the more secure today. I would like to know if there is a > SHA-1 function implemented yet of, if not, if the team h

[SQL] SHA-1 vs MD5

2007-03-07 Thread Ezequias Rodrigues da Rocha
Hi list, I know that there is a md5 internal function on postgresql, but I noticed that it isn't the more secure today. I would like to know if there is a SHA-1 function implemented yet of, if not, if the team has plan to introduce it on PostgreSQL. Regards ... -- Ezequias Rodrigues da Rocha ht