The following bug has been logged online:

Bug reference: 1194
Logged by: Yavor Shahpasov

Email address: yavo (AT) siava (DOT) 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)


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org