David G Johnston <david.g.johnston@gmail.com> writes:
> This does seem kind of a harsh for a mis-understanding that one cannot
> specify a hours offset as a valid timezone identifier. ISTM the OP was
> trying to set the timezone to EDT by specifying a -04 hours and 00 minutes
> offset (- 04 00 = -0400 )...a 4-digit input like this shouldn't be
> considered a -400 hour GMT offset...
Perhaps so, but that's not the way it's been read by past PG releases.
Changing that would be in the nature of a feature addition, not a bug fix,
IMO. (In other words, if someone wants to do it, send in a patch ...)
regards, tom lane