On Sun, May 23, 2004 at 04:58:29PM -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
