At 02:41 AM 1/26/07, Peter GILMAN wrote:
>as many of you probably already know, significant changes to daylight
>saving time are coming into effect this year, affecting the usa and
>other regions as well. in the usa, 2007 daylight saving time is set to
>begin on 11 march:
>
> http://aa.usno.navy.mil/faq/docs/daylight_time.html
PostgreSQL (since 8.0) uses its own timezone files, so it is also affected
by the 2007 DST changes.
8.1.x includes new zone files for USA.
8.1.6 and 8.2.1 have updates for Canada and Australia.
OpenBSD packages for 8.1.6 and 8.2.1 have only been available for a short time.
This script might tell you if your pgsql installation properly detects 2007
DST changes:
drop table dst;
create table dst (tz1 timestamp with time zone, tz2 timestamp with time
zone, tzage interval);
insert into dst ( select ('2005-01-02'::date+(days*7))::timestamptz as t1
from generate_series(0,150) as days );
update dst set tz2 = tz1::timestamp + '12 hours';
update dst set tzage = age( tz2 at time zone 'GMT', tz1 at time zone 'GMT' );
select * from dst where tzage <> '12 hrs';
show time zone;
drop table dst;
Frank
_______________________________________________
Openbsd-newbies mailing list
[email protected]
http://mailman.theapt.org/listinfo/openbsd-newbies
