Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns
Дата
Msg-id
22237.1265077921@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
[BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Alvaro Herrera <alvherre@commandprompt.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Thom Brown <thombrown@gmail.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Tom Lane <tgl@sss.pgh.pa.us>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Robert Haas <robertmhaas@gmail.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@kaigai.gr.jp>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Tom Lane <tgl@sss.pgh.pa.us>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Robert Haas <robertmhaas@gmail.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Tom Lane <tgl@sss.pgh.pa.us>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Robert Haas <robertmhaas@gmail.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Robert Haas <robertmhaas@gmail.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Tom Lane <tgl@sss.pgh.pa.us>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns KaiGai Kohei <kaigai@ak.jp.nec.com>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Bernd Helmle <mailings@oopsware.de>
Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns Robert Haas <robertmhaas@gmail.com>
KaiGai Kohei  writes:
> (2010/02/02 11:09), Tom Lane wrote:
>> KaiGai Kohei  writes:
>>> The attached one also clean up ATPrepAddColumn() and ATExecAddColumn() code,
>>> not only ATPrepAlterColumnType(), according to what I mentioned above.
>> 
>> What exactly do you claim is wrong with the ADD COLUMN case?

> ADD COLUMN case works correctly, but it takes unnecessary loops,
> because the find_all_inheritors() didn't provide the value to be
> set on the new pg_attribute.attinhcount.

> I'm saying it can be rewritten in more graceful manner using the
> new expected_parents argument.

I tend to think that if it ain't broke don't fix it; the odds of
actually breaking it are too high.  I don't really find the new coding
more graceful, anyway ...
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: KaiGai Kohei
Дата:
FAQ