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.
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