Re: [HACKERS] Adding type info etc for inheritance errmsg: "childtable is missing column ..."

Поиск
Список
Период
Сортировка
От Ryan Murphy
Тема Re: [HACKERS] Adding type info etc for inheritance errmsg: "childtable is missing column ..."
Дата
Msg-id CAHeEsBd-4kX3G9xiE=_trjbm8M2o69KTxN9pxERLvOHSeFhO5w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Adding type info etc for inheritance errmsg: "childtable is missing column ..."  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
Дерево обсуждения
> AFAICS, what Ryan is after would be better served by a separate tool that
> would produce a "diff" of the two tables' schemas.

Related to the other idea of seeing the problems that exist in all the columns (instead of one column at a time), I think it'd be reasonable to have a SRF that spit out everything you'd need to fix to allow inheritance to be added. A schema diff won't know what specifically has to match, but our code does.


Sure, I think that's totally true that I could just make a Set-Returning-Function (that's what SRF stands for right?) that would accomplish this.  I'll try that path instead for now.

Thanks guys!
Ryan

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [HACKERS] merging some features from plpgsql2 project
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [HACKERS] merging some features from plpgsql2 project