Package: postgresql-8.1
Version: 8.1.9-0etch1
Severity: important
Package: postgresql-8.1
Version: 8.1.9-0etch1
Severity: important
Daylight savings changes in NZ aren't correctly dealt with by the date
handling in postgres.
e.g.
SELECT '2007-10-01 12:12pm UTC'::TIMESTAMPTZ AT TIME ZONE 'NZ'
returns
2007-10-02 00:12:00
when it should be returning
2007-10-02 01:12:00
I've tried rebuilding the source package on a system with up to date
tzdata, but that doesn't appear to help either :(
I eventually grabbed the australasia file from
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/data/
created a patch from the version in the source package, and put it in
debian/patches
After buildling like this, everything worked normally.
-- System Information:
Debian Release: 4.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.21.1-20070522
Locale: LANG=en_NZ.UTF-8, LC_CTYPE=en_NZ.UTF-8 (charmap=UTF-8)
Versions of packages postgresql-8.1 depends on:
ii libc6 2.3.6.ds1-13etch2 GNU C Library: Shared libraries
ii libcomer 1.39+1.40-WIP-2006.11.14+dfsg-2 common error description library
ii libkrb53 1.4.4-7etch1 MIT Kerberos runtime libraries
ii libpam0g 0.79-4 Pluggable Authentication Modules l
ii libpq4 8.1.9-0etch1 PostgreSQL C client library
ii libssl0. 0.9.8c-4 SSL shared libraries
ii postgres 8.1.9-0etch1 front-end programs for PostgreSQL
ii postgres 71 manager for PostgreSQL database cl
postgresql-8.1 recommends no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
