Re: Add SQL function for SHA1 - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: Add SQL function for SHA1
Date
Msg-id A13E184C-45A1-4538-A027-E30D575054C2@yesql.se
Whole thread Raw
In response to Re: Add SQL function for SHA1  (Noah Misch <noah@leadboat.com>)
Responses Re: Add SQL function for SHA1  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
> On 26 Jan 2021, at 04:28, Noah Misch <noah@leadboat.com> wrote:
> 
> On Mon, Jan 25, 2021 at 10:12:28PM +0900, Michael Paquier wrote:
>> SHA-1 is now an option available for cryptohashes, and like the
>> existing set of functions of SHA-2, I don't really see a reason why we
>> should not have a SQL function for SHA1.
> 
> NIST deprecated SHA1 over ten years ago.  It's too late to be adding this.

Agreed, and pgcrypto already allows for using sha1.

It seems like any legitimate need for sha1 could be better served by an
extension rather than supplying it in-core.

--
Daniel Gustafsson        https://vmware.com/



pgsql-hackers by date:

Previous
From: "Drouvot, Bertrand"
Date:
Subject: Re: [UNVERIFIED SENDER] Re: Minimal logical decoding on standbys
Next
From: Heikki Linnakangas
Date:
Subject: Re: Protect syscache from bloating with negative cache entries