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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 24 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedAug 23, '07 at 11:50p
activeNov 11, '07 at 3:57a
posts24
users6
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase