AW: AW: ALTER TABLE DROP COLUMN

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: AW: ALTER TABLE DROP COLUMN
Дата
Msg-id 11C1E6749A55D411A9670001FA6879633680A8@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> This style of "DROP COLUMN" would change the attribute
> numbers whose positons are after the dropped column.
> Unfortunately we have no mechanism to invalidate/remove
> objects(or prepared plans) which uses such attribute numbers.
> And I've seen no proposal/discussion to solve this problem
> for DROP COLUMN feature. We wound't be able to prevent
> PostgreSQL from doing the wrong thing silently. 

That issue got me confused now (There was a previous mail where 
you suggested using logical colid most of the time). Why not use the 
physical colid in prepared objects/plans. Since those can't currently change
it seems such plans would not be invalidated.

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: AW: ALTER TABLE DROP COLUMN
Следующее
От: Franck Martin
Дата:
Сообщение: bytea type