Postgres Pro
Downloads
Home   >   mailing lists

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

From Noah Misch
Subject Re: Add SQL function for SHA1
Date
Msg-id 20210126032814.GB2427189@rfd.leadboat.com
Whole thread Raw
In response to Add SQL function for SHA1  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Add SQL function for SHA1  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Key management with tests
Next
From: Tom Lane
Date:
Subject: Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL