Re: [GENERAL] schema error upgrading from 7.1 to 7.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] schema error upgrading from 7.1 to 7.2
Дата
Msg-id 2672.1014240687@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: [GENERAL] schema error upgrading from 7.1 to 7.2  (Vivek Khera <khera@kcilink.com>)
Список pgsql-bugs
Vivek Khera <khera@kcilink.com> writes:
>  "owner_lastbilled" date DEFAULT 'CURRENT_DATE' NOT NULL,

The above was never correct.  I believe that 7.1's rather lax date
parser might have interpreted the literal as being 'current'.  7.2's
date parser would reject it, even if 'current' were still an allowed
value, which it is not.

On the other hand, invoking the function CURRENT_DATE

    "owner_lastbilled" date DEFAULT CURRENT_DATE NOT NULL,

was and remains valid.

> This is not documented in the list of changes to the Schema
> Manipulation.

Because it is not one: it is a datatype behavioral change.

            regards, tom lane

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

Предыдущее
От: "Andy Marden"
Дата:
Сообщение: Re: Dates and year 2000
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Dates and year 2000