Re: [GENERAL] SHA1 on postgres 8.3 - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [GENERAL] SHA1 on postgres 8.3
Date
Msg-id 47F510F7.5030000@dunslane.net
Whole thread Raw
In response to Re: [GENERAL] SHA1 on postgres 8.3  (Svenne Krap <svenne@krap.dk>)
List pgsql-hackers

Svenne Krap wrote:
>
> If I have a simple table now
>
> ID serial
> Username varchar
> Password varchar
>
> I currently save only md5(id || username || 'password')*  into 
> password, if I had access to sha1 (for example) i would add another 
> password column so, having for example
>
> ID serial
> Username varchar
> Password_md5 varchar
> Password_sha1 varchar
>
> No matter how you see it, I get more bits of hash to check against.
>

Really? Why stop at two, then? How many hash functions is enough?

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] ANALYZE getting dead tuple count hopelessly wrong
Next
From: Gregory Stark
Date:
Subject: Re: COPY Transform support