BUG #1194: Wrong interpretation of Asia/Nicosia timezone
The following bug has been logged online:
Bug reference: 1194
Logged by: Yavor Shahpasov
Email address: yavo@siava.org
PostgreSQL version: 7.4
Operating system: RedHat ES3
Description: Wrong interpretation of Asia/Nicosia timezone
Details:
With default settings and timezone set to Asia/Nicosia the time in the
database is 3 hours back. After changing the timezone to Europe/Athens this
is corrected.
The Asia/Nicosia timezone is equivalent to EEST time zone.
OS RedHat ES3
Postgres 7.3.4 (built from source)
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
With default settings and timezone set to Asia/Nicosia the time in the
database is 3 hours back. After changing the timezone to Europe/Athens this
is corrected.
PG 7.3 relies on the operating system to interpret time zone names, so
your problem is best reported to your OS supplier.
regards, tom lane