Re: Timezone fun (bugs and a request)

On Sun, May 23, 2004 at 04:58:29PM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre@dcc.uchile.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.