Re: logical column ordering

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: logical column ordering
Дата
Msg-id 1417009313.730933.1427227458359.JavaMail.yahoo@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: logical column ordering  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> On Thu, Mar 12, 2015 at 9:57 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
>> However, there's a difference between making a query silently given
>> different results, and breaking it completely forcing the user to
>> re-study how to write it.  I think the latter is better.  In that light
>> we should just drop attnum as a column name, and use something else:
>> maybe (attidnum, attlognum, attphysnum).  So all queries in the wild
>> would be forced to be updated, but we would not silently change
>> semantics instead.
>
> +1 for that approach.  Much better to break all of the third-party
> code out there definitively than to bet on which attribute people are
> going to want to use most commonly.

+1

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: EvalPlanQual behaves oddly for FDW queries involving system columns
Следующее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: Order of enforcement of CHECK constraints?