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