Skip site navigation (1) Skip section navigation (2)

Re: BUG #6046: select current_date crashes postgres

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>
Cc: pgsql-bugs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: BUG #6046: select current_date crashes postgres
Date: 2011-06-01 03:50:38
Message-ID: 4DE5B70E.40403@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
So much for my worries about a big long conversation. The short answer 
from Tom Lane, who committed the fixes to git:

Tom Lane wrote:
> This is the known problem with timezone abbreviations not being
> initialized correctly on Windows --- anything involving interpreting a
> "keyword" in datetime input will go belly up.  See commits 2e82d0b39,
> e05b86644.
>
> 			regards, tom lane

Those commits have a more detailed explanation, and can be found here:

http://git.postgresql.org/gitweb?p=postgresql.git;a=commit;h=2e82d0b396473b595a30f68b37b8dfd41c37dff8

http://git.postgresql.org/gitweb?p=postgresql.git;a=commit;h=e05b866447899211a0c2df31bf0671faac4fc3e5

but the short version appears to be "Fixed in the next version".

--
Craig Ringer

In response to

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2011-06-01 04:24:09
Subject: Re: [COMMITTERS] pgsql: Improve corner cases in pg_ctl's new wait-for-postmaster-startup
Previous:From: Tom LaneDate: 2011-06-01 03:47:42
Subject: Re: [PERFORM] Hash Anti Join performance degradation

pgsql-bugs by date

Next:From: DMS Tech, SarpDate: 2011-06-01 09:52:21
Subject: Re: BUG #5903: Turkish encoding problem
Previous:From: Tom LaneDate: 2011-06-01 02:53:47
Subject: Re: [BUGS] BUG #6046: select current_date crashes postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group