On 11/15/2012 02:19 PM, stuart@stuartbishop.net wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7661
> Logged by: Stuart Bishop
> Email address: stuart@stuartbishop.net
> PostgreSQL version: 9.1.6
> Operating system: Ubuntu 12.04
> Description:
>
> The pgstattuple upgrade from unpackaged script expects the pgstatindex
> function to exist, but it does not on particularly old databases (My
> pgstattuple originally installed with 8.3 or 8.4?).
That's a known issue with several of the extensions. You need to upgrade
the contrib module install to the current version, *then* wrap the
unpackaged contrib module into an extension with "FROM UNPACKAGED".
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services