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.

That means if you use function signatures from 8.0 with
pgcrypto from 8.2, they will crash on NULL.

To fix it, just reinitialize functions: \i pgcrypto.sql

-- 
marko

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to