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;
SELECT localtimestamp;
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/