From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Timezone fun (bugs and a request) |
Date: | 2004-05-23 21:02:29 |
Message-ID: | 20040523210229.GA27973@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, May 23, 2004 at 04:58:29PM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> > First I initdb'd without TZ set. So every time I start the server I get
> > LOG: could not recognize system timezone, defaulting to "Etc/GMT-4"
> > HINT: You can specify the correct timezone in postgresql.conf.
>
> So what is your system timezone anyway (and what's the platform)?
This is Linux 2.6 with glibc 2.3.3. My timezone is "America/Santiago"
(or "Chile/Continental" which is the same). The timezone is set via
/etc/localtime having the content of the timezone file (not as a symlink
as it used to be some time ago). The TZ variable isn't set.
> > alvherre=# select '10:00:00'::time at time zone 'Chile/Continental';
> > ERROR: el huso horario "chile/continental" no es reconocido
>
> This is functionality that never has existed.
Right, I know because I tried to use it with 7.4 some time ago. This
part was more a feature request than a bug report.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"XML!" Exclaimed C++. "What are you doing here? You're not a programming
language."
"Tell that to the people who use me," said XML.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-05-23 21:18:03 | I am back |
Previous Message | Tom Lane | 2004-05-23 20:58:29 | Re: Timezone fun (bugs and a request) |