"Marko Kreen" <markokr@gmail.com> writes:
On 8/24/07, Manuel Sugawara wrote:
Manuel Sugawara <masm@fciencias.unam.mx> writes:
I have a simple query that uses digest(data, 'sha1') and consistently
crashes the backend
The problem is with null arguments:

ciencias=# select digest(null, 'sha1');
In 8.0 the pgcrypto functions were non-strict and checked for NULLs.

In 8.1 they were made STRICT.

In 8.2 the NULL check were removed from code.
Not an smart move IMHO, I didn't create the function, it was created
as part of my upgrade process. May I suggest to put back the check?.

Regards,
Manuel.

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 24 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedAug 23, '07 at 11:50p
activeNov 11, '07 at 3:57a
posts24
users6
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase