Thread: 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