Re: BUG #3511: timeofday()::timestamp failing on Saturday when using australian_timezones = on

"Adam" <adam@subdesigns.net> writes:
> Conversion to a timestamp is failing to decode a timeofday() date string
> which has both 'Sat' and a timezone 'EST', when australian_timezones is
> enabled.

Yeah, there's not a lot we can do about that.  Changing timeofday()'s
output format seems a bad idea, because the only reason that function
exists at all is for backwards compatibility.  And the fact that SAT
means something else in australian_timezones mode is unfortunate, but
there's not much to be done about it either.

As of 8.2 you can use clock_timestamp() to get the number you want
without any textual conversions.  I'd recommend that ...

            regards, tom lane