Re: Segmentation fault using digest from pg_crypto

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. +