Re: timestamp default values

On Sun, Aug 07, 2005 at 12:05:43PM +1000, Brendan Jurd wrote:
> => select 'Sat Aug 06 12:00:43.668919 2005 EST'::timestamp;
> ERROR:  22007: invalid input syntax for type timestamp: "Sat Aug 06
> 12:00:43.668919 2005 EST"

What are your timezone and australian_timezones settings?  I can
duplicate the problem thusly:

set australian_timezones to on;
set timezone to 'EST';
select 'Sat Aug 06 12:00:43.668919 2005 EST'::timestamp;
ERROR:  invalid input syntax for type timestamp: "Sat Aug 06 12:00:43.668919 2005 EST"

set australian_timezones to off;
select 'Sat Aug 06 12:00:43.668919 2005 EST'::timestamp;
         timestamp
----------------------------
 2005-08-06 12:00:43.668919
(1 row)

--
Michael Fuhr