Manuel Sugawara wrote:
I have a simple query that uses digest(data, 'sha1') and consistently
crashes the backend
The problem is with null arguments:I have a simple query that uses digest(data, 'sha1') and consistently
crashes the backend
ciencias=# select digest(null, 'sha1');
el servidor ha cerrado la conexión inesperadamente,
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