I'm running a production database on Linux (select version() =
"PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3")
I read that all 8.1.* versions are DST-compliant, and sure enough, my
development server, which runs 8.1.0, switched fine, as did my 8.2.3
database at home.
The production database was upgraded a while ago to 8.1.3 from 7.*. I'm
ready to upgrade to 8.2.3 to get the the benefit of all the development
since then, but before doing that I'd like to find out what's the
problem with the DST not taking.
The timezone is 'EST5EDT', and
SELECT CASE WHEN
timestamptz '20070401 0100'
+ interval '1 hour'
>= '20070401 0300'
THEN 'Wrong' ELSE 'Right' END;
returns 'Wrong'.
Are there perhaps timezone definition files that may not have been added
when upgrading from 7.*?
Thanks
Jaime
***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
Bear Stearns does not provide tax, legal or accounting advice. You
should consult your own tax, legal and accounting advisors before
engaging in any transaction. In order for Bear Stearns to comply with
Internal Revenue Service Circular 230 (if applicable), you are notified
that any discussion of U.S. federal tax issues contained or referred to
herein is not intended or written to be used, and cannot be used, for
the purpose of: (A) avoiding penalties that may be imposed under the
Internal Revenue Code; nor (B) promoting, marketing or recommending to
another party any transaction or matter addressed herein.
***********************************************************************