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

From Stuart Bishop
Subject Re: BUG #7661: pgstattuple from unpackaged fails on old installation
Date
Msg-id CADmi=6NHD9o-FxQfA7QtB=qK18DdrooTWwgp1kMS0y4SxxYMkg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #7661: pgstattuple from unpackaged fails on old installation  (Craig Ringer <craig@2ndQuadrant.com>)
Responses Re: BUG #7661: pgstattuple from unpackaged fails on old installation
List pgsql-bugs
On Thu, Nov 15, 2012 at 1:42 PM, Craig Ringer <craig@2ndquadrant.com> wrote:

>> 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?).

pg_relpages(text) was missing too.

> 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".

Yeah, just thought I'd stick it in the... umm... bugtracker, as so far
'FROM unpackaged' has failed in 66% of up updates. Is the real
solution is for the foo--unpackaged--1.0.sql script to recreate
missing objects before adding them to the extension?


--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #7661: pgstattuple from unpackaged fails on old installation
Next
From: Craig Ringer
Date:
Subject: Re: BUG #7661: pgstattuple from unpackaged fails on old installation