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 <neilc@samurai.com>)
Список pgsql-patches
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
Дата:
Сообщение: Re: [BUGS] Bug in byteaout code in all PostgreSQL versions
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: clock_timestamp() and transaction_timestamp() function