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