Re: Re: BUG #11014: Postgres can be put into an error state by setting invalid timezone. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Re: BUG #11014: Postgres can be put into an error state by setting invalid timezone.
Date
Msg-id 28029.1405983668@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #11014: Postgres can be put into an error state by setting invalid timezone.  (David G Johnston <david.g.johnston@gmail.com>)
Responses Re: Re: BUG #11014: Postgres can be put into an error state by setting invalid timezone.  (David Johnston <david.g.johnston@gmail.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #11014: Postgres can be put into an error state by setting invalid timezone.
Next
From: David Johnston
Date:
Subject: Re: Re: BUG #11014: Postgres can be put into an error state by setting invalid timezone.