Re: Bug #885: Trouble with timestamps after vacuuming

pgsql-bugs(at)postgresql(dot)org writes:
> Query failed: ERROR: Bad timestamp external representation '06/05/2002 11:42:10 ART'

> PostgreSQL 7.2.3 on i586-pc-linux-gnu, compiled by GCC 2.96 (redhat 7.2, postgres installed from sources)

Timezone 'ART' is in the list of timezones known to Postgres, but the
table order is messed up --- it's searched by a binary search which can
fail to find entries if the alphabetical ordering isn't perfect.
You can fix it yourself if you need to --- see datetktbl[] in
src/backend/utils/adt/datetime.c.

This was only recently noticed in 7.3, and I had thought that it was a
newly introduced bug, but now I see the problem exists in 7.2.* as well.
Will patch it in 7.2.4, due out next week.

regards, tom lane