Skip site navigation (1) Skip section navigation (2)

Re: column ordering, was Re: [PATCHES] Enums patch v2

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Kenneth Marshall <ktm(at)it(dot)is(dot)rice(dot)edu>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,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 13:38:30
Message-ID: 20061220133830.GE12639@svana.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Wed, Dec 20, 2006 at 07:20:14AM -0600, Kenneth Marshall wrote:
> On Wed, Dec 20, 2006 at 01:26:59PM +0100, Peter Eisentraut wrote:
> > Am Mittwoch, 20. Dezember 2006 04:44 schrieb Tom Lane:
> > > 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.
> > 
> > The only way I can see is to make the domains of the numbers distinct.
> > 
> Negative vs. positive numbers?

Negative is used by system columns. Just adding some large constant
(say 10000) should be enough.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

pgsql-hackers by date

Next:From: Martijn van OosterhoutDate: 2006-12-20 13:48:46
Subject: Re: Load distributed checkpoint
Previous:From: Kenneth MarshallDate: 2006-12-20 13:20:14
Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2

pgsql-patches by date

Next:From: Martijn van OosterhoutDate: 2006-12-20 13:48:46
Subject: Re: Load distributed checkpoint
Previous:From: Kenneth MarshallDate: 2006-12-20 13:20:14
Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group