"David E. Wheeler" <david(at)kineticode(dot)com> writes:
> On Jan 3, 2011, at 11:42 AM, Tom Lane wrote:
>> ... that flat out doesn't work. If the upgrade script tries to add
>> functions that didn't exist in the old .so, it'll fail.
> Right, what I'm saying is that `ALTER EXTENSION foo UPGRADE;` should install the .so, too, just before it runs the upgrade scripts.
1. Doesn't work if you're upgrading an installation that has more than
one database using the extension. There's only one library directory.
2. Not possible from a permissions standpoint. Even if you think it'd
be smart to have the postgres daemon privileged enough to overwrite its
own executables, there is 0 chance of getting that past any distro.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: David E. Wheeler||Date: 2011-01-03 19:52:47|
|Subject: Re: Upgrading Extension, version numbers (was: Extensions, patch v16) |
|Previous:||From: David E. Wheeler||Date: 2011-01-03 19:51:14|
|Subject: Re: Extension upgrade, patch v0: debug help needed|