Hi, 2008/4/3, Zdenek Kotala <[EMAIL PROTECTED]>: > Premysl Paska napsal(a): > > > The following bug has been logged online: > > > > Bug reference: 4084 > > Logged by: Premysl Paska > > Email address: [EMAIL PROTECTED] > > 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
