Re: Segmentation fault using digest from pg_crypto

Marko Kreen wrote:
> 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.

I assumed that the /contrib modules changed enough that people would
always reinstall them for a major release.  However, I don't know how to
excluded them from dumps.  If you don't have the pgcrypto library
installed I think the CREATE FUNCTIONs fail because there is no library.

The strange thing is we have never gotten too many complaints about
upgrading the /contrib stuff, which is kind of odd.  We have talked
about putting each /contrib in its own schema so it could be easily
excluded but that never happened.  Putting all the contribs in one
schema might be a good middle ground.

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