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