Re: DROP COLUMN status

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DROP COLUMN status
Дата
Msg-id 15722.960474011@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: DROP COLUMN status  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Ответы Re: DROP COLUMN status  (Bruce Momjian <pgman@candle.pha.pa.us>)
RE: DROP COLUMN status  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> The implementation makes the dropped column invisible by
> changing its attnum to -attnum - offset(currently 20) and
> attnam to ("*already Dropped%d",attnum).

Ugh.  No wonder you had to hack so many places in such an ugly fashion.
Why not leave the attnum as-is, and just add a bool saying "column is
dropped" to pg_attribute?  As long as the parser ignores columns marked
that way for field lookup and expansion of *, it seems the rest of the
system wouldn't need to treat dropped columns specially in any way.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] NOTIFY/LISTEN in pgsql 7.0
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: Proposal: TRUNCATE TABLE table RESTRICT