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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

Reply via email to