Re: Segmentation fault using digest from pg_crypto

Manuel Sugawara wrote:

>> 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');
> el servidor ha cerrado la conexión inesperadamente,

Can you check if the function is defined "STRICT"? That should
automatically return null if a parameter is null without calling the
function.

Simplest way to check is probably to pg_dump --schema-only and search
for the function defn.

--
Richard Huxton
Archonet Ltd