Re: Upgrading Extension, version numbers (was: Extensions, patch v16)

David Wheeler <david@kineticode.com>

From: "David E. Wheeler" <david@kineticode.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dimitri Fontaine <dimitri@2ndQuadrant.fr>, Robert Haas <robertmhaas@gmail.com>, Bruce Momjian <bruce@momjian.us>, Oleg Bartunov <oleg@sai.msu.su>, David Fetter <david@fetter.org>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2011-01-03T19:52:47Z
Lists: pgsql-hackers
On Jan 3, 2011, at 11:51 AM, Tom Lane wrote:

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

Okay, got it.

Best,

David