Marko Kreen wrote:
On 11/10/07, Bruce Momjian 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 <>

+ If your life is a hard drive, Christ can be your backup. +

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 18 of 24 | next ›
Discussion Overview
grouppgsql-hackers @
postedAug 23, '07 at 11:50p
activeNov 11, '07 at 3:57a



site design / logo © 2022 Grokbase