Re: Assigning a timestamp without timezone to a timestamp

chrisj <chrisj.wood@sympatico.ca> writes:
> It works fine with fixed offset timezones, but when I try it with EST5EDT
> I get the following:
> ERROR:  invalid input syntax for type timestamp with time zone: "2006-07-13
> 09:20:00 EST5EDT"

Try it with "America/New_York".  The datetime parser seems to think that
a timezone name shouldn't contain digits ... which is bogus, but we'll
have to think carefully about how to improve it ...
        regards, tom lane