One more hack to make contrib upgrades from 9.0 match fresh 9.1 installs.
intarray and tsearch2 both reference core support functions in their GIN
opclasses, and the signatures of those functions changed for 9.1. We added
backwards-compatible pg_proc entries for the functions in order to allow
9.0 dump files to be restored at all, but that hack leaves the opclasses
pointing at pg_proc entries different from what they'd point to if the
contrib modules were installed fresh in 9.1. To forestall any possibility
of future problems, fix the opclasses to match fresh installs via the
expedient of direct UPDATEs on pg_amproc in the update-from-unpackaged
scripts. (Yech ... but the alternatives are worse, or require far more
effort than seems justified right now.)
Note: updating pg_amproc is sufficient because there will be no pg_depend
entries corresponding to these dependencies, since the referenced functions
are all pinned.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/472f608e436a41865b795c999bda3369725fa097
Modified Files
--------------
contrib/intarray/intarray--unpackaged--1.0.sql | 18 ++++++++++
contrib/tsearch2/tsearch2--unpackaged--1.0.sql | 41 ++++++++++++++++++++++++
2 files changed, 59 insertions(+), 0 deletions(-)