From:
"Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc:
"Martijn van Oosterhout" <kleptog(at)svana(dot)org>,"Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>,<pgsql-hackers(at)postgresql(dot)org>,"Gregory Stark" <stark(at)enterprisedb(dot)com>
Subject:
Re: column ordering, was Re: [PATCHES] Enums patch v2
Date:
2006-12-22 09:25:08
Message-ID:
E1539E0ED7043848906A8FF995BDA57901A34F65@m0143.s-mxs.net (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
> >> You could make a case that we need *three* numbers: a permanent
column
> >> ID, a display position, and a storage position.
>
> > Could this not be handled by some catalog fixup after an add/drop?
If we
> > get the having 3 numbers you will almost have me convinced that this
> > might be too complicated after all.
>
> Actually, the more I think about it the more I think that 3 numbers
> might be the answer. 99% of the code would use only the permanent ID.
I am still of the opinion, that the system tables as such are too
visible
to users and addon developers as to change the meaning of attnum.
And I don't quite see what the point is. To alter a table's column you
need
an exclusive lock, and plan invalidation (or are you intending to
invalidate only
plans that reference * ?). Once there you can just as well fix the
numbering.
Yes, it is more work :-(
Andreas
In response to
pgsql-hackers by date
Next :From: Takayuki TsunakawaDate: 2006-12-22 09:38:49Subject : Re: Load distributed checkpointPrevious :From : Pavel StehuleDate : 2006-12-22 09:10:15Subject : Re: configure problem --with-libxml
pgsql-patches by date
Next :From: Takayuki TsunakawaDate: 2006-12-22 09:38:49Subject : Re: Load distributed checkpointPrevious :From : ITAGAKI TakahiroDate : 2006-12-22 09:09:33Subject : Re: Load distributed checkpoint
