Re: BUG #7661: pgstattuple from unpackaged fails on old installation

Craig Ringer <craig(at)2ndQuadrant(dot)com> writes:
> On 11/15/2012 03:32 PM, Stuart Bishop wrote:
>>> 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?

> Extensions were created because upgrading DBs that used contrib modules
> was a painful mess.

Yeah. The goal we set ourselves when making the foo--unpackaged scripts
was only to be able to upgrade from the immediately preceding form of
the contrib module. I think it's probably true that in many cases
adding CREATE OR REPLACE-type commands could allow upgrading from
earlier versions as well. But it would be a lot of work to research
what's needed and create/test a patch, and it would be work whose value
lessens with every passing day. If there's somebody out there who's
sufficiently annoyed to do that work, have at it.

regards, tom lane