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

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: column ordering, was Re: [PATCHES] Enums patch v2
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57901A34ECC@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: column ordering, was Re: [PATCHES] Enums patch v2  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: column ordering, was Re: [PATCHES] Enums patch v2  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: Stats Collector Oddity
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: column ordering, was Re: [PATCHES] Enums patch v2