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/

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to