On 8/24/07, Manuel Sugawara wrote:
Manuel Sugawara <masm@fciencias.unam.mx> writes:
ciencias=# select digest(null, 'sha1');
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:crashes the backend
ciencias=# select digest(null, 'sha1');
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
