Re: preliminary: logical column order

Поиск
Список
Период
Сортировка
Искать
От
Andreas Pflug
Тема
Re: preliminary: logical column order
Дата
Msg-id
3FCA1BE9.3030508@pse-consulting.de
Ответ на
Список
Дерево обсуждения
preliminary: logical column order Neil Conway <neilc@samurai.com>
Re: preliminary: logical column order Tom Lane <tgl@sss.pgh.pa.us>
Re: preliminary: logical column order Neil Conway <neilc@samurai.com>
Re: preliminary: logical column order Andreas Pflug <pgadmin@pse-consulting.de>
Re: preliminary: logical column order Manfred Koizar <mkoi-pg@aon.at>
I wonder if it wouldn't be easier to reorder the TupDesc->attrs[] array
according to an attphysid when filling the TupDesc structure, right
after a column was dropped/recreated (before any indexes/constraints are
recreated), so attnum remains, while storage changes.

Example:

before:
attnum   attphysid  attname attisdropped

1         1         foo           f
2         2         bar           f

after drop/recreate col:
1         3         foo           f
2         2         bar           f
3         1         foo_del       t

resulting in an attrs array
attrs[0] describing physical col 3
attrs[1] describing physical col 2
attrs[2] describing physical col 1



Regards,
Andreas


В списке pgsql-patches по дате отправления
От: Bruce Momjian
Дата:
От: Bruce Momjian
Дата:
FAQ