Re: timestamp default values

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?

In response to

Responses

Browse pgsql-general by date

  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