Re: column ordering, was Re: [PATCHES] Enums patch v2 - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: column ordering, was Re: [PATCHES] Enums patch v2
Date
Msg-id E1539E0ED7043848906A8FF995BDA57901A34ECC@m0143.s-mxs.net
Whole thread Raw
In response to Re: column ordering, was Re: [PATCHES] Enums patch v2  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: column ordering, was Re: [PATCHES] Enums patch v2  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
> > I don't think we should expose the offset to user view at all - this
is
> > just for internal use, no?
>
> The thing is, physical index numbers has meaning, the logical index
> number does not. In a view definition we're going to store the
physical
> index, not the logical one, for example. We don't want rearranging
> columns to invalidate view definitions or plans.

I think we lack a definition here:

logical number:    the order of columns when doing select *
physical number:    the position inside the heap tuple (maybe with
offset)

All views and plans and index definitions and most everyting else
needs to reference the logical number.

Andreas


pgsql-hackers by date:

Previous
From: Chris Browne
Date:
Subject: Re: Stats Collector Oddity
Next
From: Martijn van Oosterhout
Date:
Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2