Craig Ringer <craig@postnewspapers.com.au> writes:
> On 1/06/2011 9:01 AM, Craig Ringer wrote:
>> Is anyone aware of any changes between 9.0 and 9.1beta that messed with
>> time zone handling and loading?
> By the way, it looks like using any of:
> SELECT 'now'::timestamp;
> SELECT 'now'::timestamptz;
> SELECT current_time;
> SELECT current_date;
> SELECT localtime;
> SELECT localtimestamp;
> SELECT CAST( now() AS date );
> will also trigger a crash.
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
