From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Bruce Momjian <bruce(at)momjian(dot)us>
Cc:
Andrew Dunstan <andrew(at)dunslane(dot)net>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>,
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Subject:
Re: Removing pg_migrator limitations
Date:
2009-12-19 01:31:20
Message-ID:
15594.1261186280@sss.pgh.pa.us (view raw or flat )
Thread:
2009-12-18 19:29:18 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-18 19:52:32 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-12-18 20:17:38 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-18 21:42:36 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-12-18 21:45:23 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-18 21:57:08 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-12-18 22:02:14 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-19 00:49:18 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-18 23:44:28 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-12-18 23:55:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-12-19 00:09:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-19 00:17:08 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-12-19 00:27:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-19 01:11:27 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-19 00:25:53 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-12-19 01:09:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-19 01:31:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-20 01:58:52 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-20 17:52:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-20 18:07:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-20 18:49:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-20 18:58:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-12-20 19:08:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-20 19:29:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-12-20 19:39:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-21 04:58:01 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-21 05:16:16 from "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
2009-12-21 05:18:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-21 05:29:48 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-23 19:08:38 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-23 19:17:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-23 19:53:50 from Greg Stark <gsstark(at)mit(dot)edu>
2009-12-23 20:09:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-23 21:23:44 from Greg Stark <gsstark(at)mit(dot)edu>
2009-12-23 21:34:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-23 23:12:36 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-24 01:30:23 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-12-24 01:33:38 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-24 04:45:11 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-24 16:03:40 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-24 16:19:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-24 21:52:20 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-24 22:17:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-24 22:34:43 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-24 22:40:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-24 22:53:11 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-25 03:05:49 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-26 18:50:33 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-27 14:52:43 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-27 16:11:07 from Greg Stark <stark(at)mit(dot)edu>
2009-12-27 20:13:23 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-27 20:35:37 from Greg Stark <stark(at)mit(dot)edu>
2009-12-27 22:15:28 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-27 22:51:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-12-25 06:17:35 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-25 15:12:35 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-26 16:55:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-24 22:23:05 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-12-24 16:27:04 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-12-24 22:10:57 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-19 01:27:06 from Joe Conway <mail(at)joeconway(dot)com>
2009-12-19 01:39:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-20 03:46:47 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-20 03:52:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-12-20 03:59:13 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-22 22:04:15 from decibel <decibel(at)decibel(dot)org>
2009-12-23 19:12:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-27 14:53:52 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-27 19:16:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-12-28 07:11:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-12-28 15:48:42 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-28 15:58:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-12-28 16:31:13 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> ... The idea I had was to create a global structure:
> struct pg_migrator_oids {
> Oid pg_type;
> Oid pg_type_array;
> ...
> }
> This would initialize to zero as a global structure, and only
> pg_migrator server-side functions set it.
I would prefer *not* to do that, as that makes the list of settable oids
far more public than I would like; also you are totally dependent on
pg_migrator and the backend to be in sync about the definition of that
struct, which is going to be problematic in alpha releases in
particular, since PG_VERSION isn't going to distinguish them.
What I had in mind was more like
static Oid next_pg_class_oid = InvalidOid;
void
set_next_pg_class_oid(Oid oid)
{
next_pg_class_oid = oid;
}
in each module that needs to be able to accept a next-oid setting,
and then the pg_migrator loadable module would expose SQL-callable
wrappers for these functions. That way, any inconsistency shows up as
a link error: function needed not present.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Simon RiggsDate: 2009-12-19 01:32:45
Subject : pgsql: Allow read only connections during recovery, known as Hot
Previous :From : Joe ConwayDate : 2009-12-19 01:27:06
Subject : Re: Removing pg_migrator limitations