From:
"David E(dot) Wheeler" <david(at)kineticode(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>,
Robert Haas <robertmhaas(at)gmail(dot)com>,
Bruce Momjian <bruce(at)momjian(dot)us>,
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>,
David Fetter <david(at)fetter(dot)org>,
PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Upgrading Extension, version numbers (was: Extensions, patch v16)
Date:
2011-01-03 19:43:43
Message-ID:
3675513E-F09E-4DCC-8C96-4C17128A2084@kineticode.com (view raw or flat )
Thread:
2010-12-09 20:34:05 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-09 21:43:03 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 08:26:44 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 15:32:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 15:46:48 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 16:24:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 16:35:45 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 17:30:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 18:10:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-10 18:20:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 18:21:56 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 19:28:17 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 19:38:38 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 19:42:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 19:47:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 20:00:09 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 20:17:31 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 20:24:44 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-10 20:33:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 20:34:28 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 21:55:08 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-10 22:00:18 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 22:22:26 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 22:43:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 20:42:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-12-10 20:45:37 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-12-10 20:54:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 20:48:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 21:50:59 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 22:02:06 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-12-10 22:25:14 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 22:32:09 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 22:35:59 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 22:43:32 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 22:50:09 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 22:58:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 23:00:47 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-11 20:09:19 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-11 21:35:24 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-13 14:42:43 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-12-13 14:55:04 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-13 15:18:51 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-12-13 15:50:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-13 16:06:32 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-12-13 16:14:13 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 22:40:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 22:48:33 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 22:55:43 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 22:58:29 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 23:03:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 23:16:16 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-11 00:15:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-11 00:17:55 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-11 00:39:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-11 00:46:08 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-11 01:02:55 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-11 01:14:25 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-12-11 03:14:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-11 21:09:08 from David Fetter <david(at)fetter(dot)org>
2010-12-11 21:30:54 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-12 14:32:01 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2010-12-29 20:00:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-12-29 20:01:09 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-29 20:23:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-29 20:36:44 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-29 21:27:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-29 21:34:52 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-29 22:01:12 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-03 19:08:45 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-03 19:42:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-03 19:43:43 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-03 19:51:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-03 19:52:47 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-03 19:46:47 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-03 19:59:16 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-03 20:23:29 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-03 22:05:48 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-04 08:46:07 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-04 17:26:06 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-04 19:48:46 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-04 19:53:42 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-04 20:05:08 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-01-04 20:25:56 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-05 18:05:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-05 18:36:20 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-05 19:36:24 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2010-12-10 17:31:50 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-12-10 17:30:49 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Lists:
pgsql-hackers
On Jan 3, 2011, at 11:42 AM, Tom Lane wrote:
> It is, but I don't see any alternative. As Dimitri said, the .so will
> typically be installed by a packaging system, so we don't have any
> opportunity to run SQL code beforehand. In any case ...
>
>> The new .so should not be installed until the upgrade is been run.
>
> ... 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.
Best,
David
In response to
Responses
pgsql-hackers by date
Next :From: Joel JacobsonDate: 2011-01-03 19:46:02Subject : Re: pg_dump --split patchPrevious :From : Tom LaneDate : 2011-01-03 19:42:25Subject : Re: Upgrading Extension, version numbers (was: Extensions, patch v16)
