"Marko Kreen" <[EMAIL PROTECTED]> writes:
> On 8/24/07, Manuel Sugawara <[EMAIL PROTECTED]> wrote:
>> Manuel Sugawara <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
