From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
"David E(dot) Wheeler" <david(at)kineticode(dot)com>
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:42:25
Message-ID:
23428.1294083745@sss.pgh.pa.us (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
"David E. Wheeler" <david(at)kineticode(dot)com> writes:
> On Dec 29, 2010, at 2:01 PM, Dimitri Fontaine wrote:
>> At the time you tell PostgreSQL about the new extension, the shared
>> object file has been in place for some time already, and the upgrade SQL
>> script has not been ran yet.
> That sounds dangerous.
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.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: David E. WheelerDate: 2011-01-03 19:43:43Subject : Re: Upgrading Extension, version numbers (was: Extensions, patch v16) Previous :From : Robert HaasDate : 2011-01-03 19:26:28Subject : Re: back branches vs. VS 2008
