Re: BUG #7661: pgstattuple from unpackaged fails on old installation - Mailing list pgsql-bugs

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