Re: possible when setting the timezone

From: Nick Martens <nick80(at)xs4all(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: possible when setting the timezone
Date: 2006-01-10 19:52:30
Message-ID: 200601102052.30162.nick80@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

i just tried the commands from the psql console, and seems to crash then too.

mydb=# SET TimeZone TO 'America/Indiana';
ERROR: unrecognized time zone name: "America/Indiana"
mydb=# SELECT memo_id, memo_title, memo_comment,
mydb-# memo_date::timestamp, bedrijf_id, persoon_id, initialenachternaam,
mydb-# bedrijfsnaam FROM v_memos ORDER BY memo_date DESC LIMIT 30 OFFSET 0;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Juan Pablo Yañez 2006-01-10 19:52:45 Unsuscribe
Previous Message Tom Lane 2006-01-10 19:47:03 Re: possible when setting the timezone