Tom Lane wrote:
>> SELECT 'INFINITY'::TIMESTAMP;
>>
>
> Hmm ... I bet this is related to the recent reports about ALTER USER
> VALID UNTIL 'infinity' crashing on Windows. Can the people seeing this
> get through the regression tests? Perhaps more to the point, what is
> their setting of TimeZone? What does the pg_timezone_abbrevs view show
> for them?
>
I must have missed that thread, I think I'm missing one of these lists
(pgsql-bugs maybe?). I've cc'd Mark Watson so maybe you can get better
responses without me in the middle if needed; for this one, he reports:
Show timezone gives US/Eastern
Select * from pg_timezone_abbrevs returns zero rows
My Linux system that doesn't have this problem is also in US/Eastern,
too, but I get 189 rows in pg_timezone_abrevs.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD