From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc:
pgsql-hackers(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org>,
Andrew Dunstan <andrew(at)dunslane(dot)net>,
Gregory Stark <stark(at)enterprisedb(dot)com>
Subject:
Re: column ordering, was Re: [PATCHES] Enums patch v2
Date:
2006-12-20 03:44:53
Message-ID:
16297.1166586293@sss.pgh.pa.us (view raw or flat )
Thread:
2006-12-19 02:34:36 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-19 08:09:47 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2006-12-19 08:23:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-19 14:34:27 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 14:58:48 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2006-12-19 15:11:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 15:22:13 from Gregory Stark <stark(at)enterprisedb(dot)com>
2006-12-19 15:48:41 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 16:25:04 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 03:35:21 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2006-12-20 03:44:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 04:12:50 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 04:29:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 11:33:53 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2006-12-20 14:19:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-20 14:27:13 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 16:20:16 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-20 16:24:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 21:23:49 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2006-12-21 16:26:30 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-20 12:06:54 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:15:05 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 20:17:12 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 14:39:07 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-21 15:27:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-21 15:37:03 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 15:50:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:07:20 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:15:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:27:44 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-21 16:43:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 17:09:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-22 01:48:49 from Gregory Stark <gsstark(at)mit(dot)edu>
2006-12-22 02:28:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-22 09:25:08 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-30 04:46:27 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-02 05:43:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-21 16:47:56 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:59:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:06:53 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-21 16:11:46 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:18:02 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-20 12:26:59 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-20 13:20:14 from Kenneth Marshall <ktm(at)it(dot)is(dot)rice(dot)edu>
2006-12-20 13:38:30 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:11:48 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-20 14:36:32 from Richard Huxton <dev(at)archonet(dot)com>
2006-12-20 13:59:21 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-19 15:19:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 01:39:58 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-20 11:03:11 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:49:32 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 08:51:01 from David Fetter <david(at)fetter(dot)org>
2006-12-19 09:58:48 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-20 02:00:48 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-20 01:23:02 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2007-02-02 03:50:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-02 15:54:44 from Neil Conway <neilc(at)samurai(dot)com>
2007-02-14 00:03:47 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2007-02-21 17:06:10 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers pgsql-patches
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> On Tuesday 19 December 2006 11:25, Martijn van Oosterhout wrote:
>> A patch to allow seperate physical and logical orderings was submitted
>> and rejected. Unless something has changed on that front, any
>> discussion in this direction isn't really useful.
> The patch was rejected on technical means, and the author decided it was too
> much work to finish it. If someone wanted to try and complete that work I
> don't think anyone would stand against it.
Apparently you don't remember the discussion. The fundamental objection
to it was that it would create a never-ending source of bugs, ie, using
the logical column number where the physical number was required or vice
versa. Even assuming that we could eliminate all such bugs in the code
base at any instant, what would prevent introduction of another such bug
in every patch? Most ordinary test cases would fail to expose the
difference.
If you can show me a reasonably bulletproof or machine-checkable way to
keep the two kinds of column numbers distinct, I'd be all for it. But
without that, the answer will remain no.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Alvaro HerreraDate: 2006-12-20 03:54:26Subject : Re: Companies Contributing to Open SourcePrevious :From : Alvaro HerreraDate : 2006-12-20 03:43:11Subject : Re: Autovacuum Improvements
pgsql-patches by date
Next :From: Takayuki TsunakawaDate: 2006-12-20 04:06:37Subject : Re: Load distributed checkpointPrevious :From : Robert TreatDate : 2006-12-20 03:35:21Subject : Re: column ordering, was Re: [PATCHES] Enums patch v2
