Re: [BUGS] possible when setting the timezone

2006-01-10 Thread Nick Martens
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,

Re: [BUGS] possible when setting the timezone

2006-01-10 Thread Nick Martens
_id) REFERENCES bedrijven(bedrijf_id) "memos_persoon_id_fkey" FOREIGN KEY (persoon_id) REFERENCES personen(persoon_id) On Tuesday 10 January 2006 19:23, Tom Lane wrote: > Nick Martens <[EMAIL PROTECTED]> writes: > > Jan 10 17:14:40 dndwebdev01 postgres[17374]:

[BUGS] possible when setting the timezone

2006-01-10 Thread Nick Martens
Hello, I am developing an php application and by mistake a wrong timezone was set after I initialized the connection, which resulted in a core dump of the current process. The postgres version is 8.0.3 running on a freebsd 6.0-RELEASE machine with the generic kernel. I tried searching for simila