Re: ALTER TABLE DROP COLUMN

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема Re: ALTER TABLE DROP COLUMN
Дата
Msg-id 39457D58.F342701A@nimrod.itg.telecom.com.au
обсуждение исходный текст
Ответ на RE: ALTER TABLE DROP COLUMN  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Ответы RE: ALTER TABLE DROP COLUMN  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
Hiroshi Inoue wrote:

> I don't understand inheritance well. In the near future wouldn't the
> implementation require e.g. attid which is common to all children
> of a parent and is never changed ? If so,we would need the third
> attid field which is irrevalent to physical/logical position. If not,
> physical column number would be sufficient .

We only need something like a unique attid of course if we support
column renaming in child tables. Otherwise the attname is sufficient to
match up child-parent columns.

If/when we support renaming, probably a parent_column_oid in
pg_attribute might be one way to go.

Your idea seems fine Tom.


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

Предыдущее
От: Chris Bitmead
Дата:
Сообщение: Re: ALTER TABLE DROP COLUMN
Следующее
От: "valter m"
Дата:
Сообщение: how an app can know when a table is altered ?