Re: Segmentation fault using digest from pg_crypto - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Segmentation fault using digest from pg_crypto
Date
Msg-id 200711092343.lA9NhZ006419@momjian.us
Whole thread Raw
In response to Re: Segmentation fault using digest from pg_crypto  ("Marko Kreen" <markokr@gmail.com>)
Responses Re: Segmentation fault using digest from pg_crypto  ("Marko Kreen" <markokr@gmail.com>)
List pgsql-hackers
Marko Kreen wrote:
> On 11/7/07, Bruce Momjian <bruce@momjian.us> wrote:
> > OK, should we add a mention in the 8.2.6 release notes or put it in the
> > 8. notes and figure if someone is upgrading they will read the 8.2
> > notes?  What would the description be?
> 
> """
> Note about pgcrypto - the functions were made STRICT in 8.1
> and the NULL check was removed in 8.2 from C code.  If some
> database still contains non-STRICT signatures from 8.0 and below,
> the functions will crash on NULL.  To fix it the pgcrypto.sql
> needs to be run that will re-create the signatures.
> """
> 
> Hm.  Is there way to say that better?

OK, first question.  How would someone have the 8.0 signatures in 8.2? 
Don't they reinstall pgcrypto for every major release?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: "Marko Kreen"
Date:
Subject: Re: Segmentation fault using digest from pg_crypto
Next
From: "Scott Marlowe"
Date:
Subject: Re: [GENERAL] Is "query" a reserved word in 8.3 plpgsql?