On 8/24/07, Manuel Sugawara wrote:
Manuel Sugawara <masm@fciencias.unam.mx> writes:
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');
In 8.0 the pgcrypto functions were non-strict and checked for NULLs.

In 8.1 they were made STRICT.

In 8.2 the NULL check were removed from code.

That means if you use function signatures from 8.0 with
pgcrypto from 8.2, they will crash on NULL.

To fix it, just reinitialize functions: \i pgcrypto.sql

--
marko

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 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