Re: PostgreSQL Inheritance and column mapping

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: PostgreSQL Inheritance and column mapping
Дата
Msg-id
25921.1412258435@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
PostgreSQL Inheritance and column mapping Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: PostgreSQL Inheritance and column mapping Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL Inheritance and column mapping Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: PostgreSQL Inheritance and column mapping Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: PostgreSQL Inheritance and column mapping John R Pierce <pierce@hogranch.com>
Achilleas Mantzios  writes:
> Was there ever any discussion.thought about being able to follow a non-strict by name
> column mapping between inherited tables and father tables?

No.  You could use a view with UNION ALL perhaps.

(The subtext here is that past discussion of inheritance has generally
focused on *eliminating* differences between parent and child tables, so
as to make query planning and execution faster/simpler.  That is, when the
discussion doesn't consist of somebody wanting to get rid of inheritance
altogether.  I think the enthusiasm for supporting even-less-compatible
child tables will be not distinguishable from zero.)

			regards, tom lane

В списке pgsql-general по дате отправления
От: John R Pierce
Дата:
От: Adam Brusselback
Дата:
FAQ