Re: Column storage positions

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at>
Cc: Phil Currier <pcurrier(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Column storage positions
Date: 2007-02-22 17:16:13
Message-ID: 45DDCFDD.5090408@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Zeugswetter Andreas ADI SD wrote:
> And I also see a lot of unhappiness from users of system tables
> when column numbers all over the system tables would not be logical
> column
> positions any more.
>
>

Are you arguing against the feature? Or against the suggested design?

I should have thought (without much looking) one possible way to
implement it would be to put Oids on pg_attribute for the permanent id,
and keep attnum for the (now mutable) logical order, adding a further
column for the physical order.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2007-02-22 17:17:22 Re: tsearch in core patch, for inclusion
Previous Message Joshua D. Drake 2007-02-22 17:09:48 Re: [Monotone-devel] Re: SCMS question