Tom Lane wrote: > "Marko Kreen" <[EMAIL PROTECTED]> writes: > > On 11/10/07, Bruce Momjian <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
