"Marko Kreen" <markokr(at)gmail(dot)com> writes:
> On 8/24/07, Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> wrote:
>> Manuel Sugawara <masm(at)fciencias(dot)unam(dot)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.