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

From Michael Paquier
Subject Re: Add SQL function for SHA1
Date
Msg-id YBDHfHufJaO+xcy2@paquier.xyz
Whole thread Raw
In response to Re: Add SQL function for SHA1  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: Add SQL function for SHA1  (Sehrope Sarkuni <sehrope@jackdb.com>)
List pgsql-hackers
On Tue, Jan 26, 2021 at 10:38:43AM +0100, Daniel Gustafsson wrote:
> 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.

Both of you telling the same thing is enough for me to discard this
new stuff.  I'd like to refactor the code anyway as that's a nice
cleanup, and this would have the advantage to make people look at
cryptohashfuncs.c if introducing a new type.  After sleeping about it,
I think that I would just make MD5 and SHA1 issue an elog(ERROR) if
the internal routine is taken in those cases, like in the attached.

If there are any comments or objections to the refactoring piece,
please let me know.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: wiki:PostgreSQL_14_Open_Items
Next
From: Zhihong Yu
Date:
Subject: Re: logical replication worker accesses catalogs in error context callback