Re: timestamp default values

Поиск
Список
Период
Сортировка
От Brendan Jurd
Тема Re: timestamp default values
Дата
Msg-id 37ed240d050806193861cf2de0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: timestamp default values  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: timestamp default values  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Here we go ... line 498 of backend/utils/adt/datetime.c:

/* Used for SET australian_timezones to override North American ones */
static datetkn australian_datetktbl[] = {
    {"acst", TZ, POS(38)},        /* Cent. Australia */
    {"cst", TZ, POS(42)},        /* Australia Central Std Time */
    {"east", TZ, POS(40)},        /* East Australian Std Time */
    {"est", TZ, POS(40)},        /* Australia Eastern Std Time */
    {"sat", TZ, POS(38)},
};

"sat" is being parsed as a timezone.  Probably "South Australian Time".

I'm guessing the parser is throwing an error because it thinks I'm
trying to give it two different timezones.

Are there any good reasons why the output of timeofday() needs to
include the three letter day-of-week?  Could we either remove it, or
perhaps change it to the full day-of-week (e.g. "Saturday"), which
cannot be confused with a timezone?

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

Предыдущее
От: Brendan Jurd
Дата:
Сообщение: Re: timestamp default values
Следующее
От: Tom Lane
Дата:
Сообщение: Re: timestamp default values