Re: Segmentation fault using digest from pg_crypto

"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.
        regards, tom lane