From: | "Premek Paska" <premek(dot)paska(at)gmail(dot)com> |
---|---|
To: | "Zdenek Kotala" <Zdenek(dot)Kotala(at)sun(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4084: Some DST timezones switche to summer time (one week) later |
Date: | 2008-04-05 15:05:42 |
Message-ID: | 9cca5fcb0804050805i8dab962ifcc50adf16860058@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
2008/4/3, Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com>:
> Premysl Paska napsal(a):
>
> > The following bug has been logged online:
> >
> > Bug reference: 4084
> > Logged by: Premysl Paska
> > Email address: premek(dot)paska(at)gmail(dot)com
> > PostgreSQL version: 8.0.15
> > Operating system: Linux
> > Description: Some DST timezones switche to summer time (one week)
> > later
> > Details:
> > We use TIMESTAPM WITH TIMEZONE to insert datetime values into our DB. The
> > problem is with the CEST timezone (Central European Summer Time; Prague)
> and
> > possibly some others.
> >
> > The summer time started on 2008-03-30 02:00 in the CEST timezone shifting
> > offset with respect to UTC from +1 to +2. But PostgreSQL kept inserting
> with
> > the former +1 offset after this day. We tested it for various other dates
> > and realized that it switches to the summer time one week later
> > (2008-04-06).
> >
>
> Do you use system timezone for PostgreSQL or do you use postgres timezone
> file? But anyway there was not any change in CET timezone for a long time.
>
We use system timezone (the default). (It's an installation from a
Gentoo ebuild.)
>
> > The same problem was reported with a North American timezone.
> >
> > (BTW we have another problem with TZ, after we change TZ in the system, we
> > must restart Postgres to apply it also to the DB.)
> >
>
> Yes, PostgreSQL caches TZ data, however any others application in system
> could be confused too when you update TZ data as well.
>
> Zdenek
>
I mean switching to a different timezone, not changing TZ data. But it
is not important, we've already worked it around.
>
>
Mej se,
Premek
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-05 15:26:46 | Re: BUG #4092: initdb fails if the xlog directory is the same as [pg_data]/pg_xlog |
Previous Message | Peter Koczan | 2008-04-04 22:11:25 | BUG #4092: initdb fails if the xlog directory is the same as [pg_data]/pg_xlog |