Re: Segmentation fault using digest from pg_crypto

Tom Lane wrote:
> "Marko Kreen" <markokr@gmail.com> writes:
> > On 11/10/07, Bruce Momjian <bruce@momjian.us> wrote:
> >> OK, first question.  How would someone have the 8.0 signatures in 8.2?
> >> Don't they reinstall pgcrypto for every major release?
> 
> > Why reinstall if the functions come from dump?
> 
> > At least in skype we stumbled on the problem.  But if the reinstall
> > is widespread practice, then indeed it may not be worth bothering.
> 
> If you don't re-run a contrib module's sql script then you don't get any
> new functions that may have been added to the module.  So I think the
> real issue here is that we ought to deprecate the idea of skipping that
> step, period.

When did we ever promote such a skipping idea?  Seems we need to add
some documentation for this.  Once we get the /contrib docs moved to
SGML I can add something.

The good news is that the scripts have CREATE OR REPLACE function so it
would clean up everything to match the library you just installed.

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