From: | Brendan Jurd <direvus(at)gmail(dot)com> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: timestamp default values |
Date: | 2005-08-07 02:38:59 |
Message-ID: | 37ed240d050806193861cf2de0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Google Mike | 2005-08-07 02:59:06 | Poll on your LAPP Preferences |
Previous Message | Brendan Jurd | 2005-08-07 02:34:30 | Re: timestamp default values |