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