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/