Re: BETWEEN Node & DROP COLUMN

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: BETWEEN Node & DROP COLUMN
Дата
Msg-id GNELIHDDFBOCMGBFGEFOGEPOCCAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: BETWEEN Node & DROP COLUMN  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
> > It merrily renames the column in the child table (I tried it).  When
> > SELECTing the parent, bogus data appears.  Looks like a bug to me.
> > Maybe the ALTER TABLE ...  RENAME COLUMN code should check for inherited
> > columns before renaming them.
>
> Hmmm...so how does one check if one is a child in an inheritance
> hierarchy?

Actually, more specifically, how does one check that the column being
dropped or renamed appears in none of one's parent tables?

I notice there's no find_all_ancestors() function...

Chris





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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: DROP COLUMN Progress
Следующее
От: "J. R. Nield"
Дата:
Сообщение: Re: Issues Outstanding for Point In Time Recovery (PITR)