Re: preliminary: logical column order
От
Andreas Pflug
Тема
Re: preliminary: logical column order
Дата
Msg-id
3FCA1BE9.3030508@pse-consulting.de
Ответ на
Re: preliminary: logical column order (Neil Conway)
Список
Дерево обсуждения
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
Дата: