Re: [BUGS] BUG #6046: select current_date crashes postgres

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;
SELECTlocaltimestamp;  SELECT CAST( now() AS date );
 

will also trigger a crash. However, none of these statements do:
  SELECT current_timestamp;  SELECT now();  SELECT now() :: timestamptz;  SELECT now() :: timestamp;

-- 
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/