Your message dated Thu, 17 Jan 2008 19:52:16 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#443360: fixed in postgresql-8.1 8.1.10-0etch1 has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message ---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
--- End Message ---
--- Begin Message ---Source: postgresql-8.1 Source-Version: 8.1.10-0etch1 We believe that the bug you reported is fixed in the latest version of postgresql-8.1, which is due to be installed in the Debian FTP archive: libecpg-compat2_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/libecpg-compat2_8.1.10-0etch1_i386.deb libecpg-dev_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/libecpg-dev_8.1.10-0etch1_i386.deb libecpg5_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/libecpg5_8.1.10-0etch1_i386.deb libpgtypes2_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/libpgtypes2_8.1.10-0etch1_i386.deb libpq-dev_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/libpq-dev_8.1.10-0etch1_i386.deb libpq4_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/libpq4_8.1.10-0etch1_i386.deb postgresql-8.1_8.1.10-0etch1.diff.gz to pool/main/p/postgresql-8.1/postgresql-8.1_8.1.10-0etch1.diff.gz postgresql-8.1_8.1.10-0etch1.dsc to pool/main/p/postgresql-8.1/postgresql-8.1_8.1.10-0etch1.dsc postgresql-8.1_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/postgresql-8.1_8.1.10-0etch1_i386.deb postgresql-client-8.1_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/postgresql-client-8.1_8.1.10-0etch1_i386.deb postgresql-contrib-8.1_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/postgresql-contrib-8.1_8.1.10-0etch1_i386.deb postgresql-doc-8.1_8.1.10-0etch1_all.deb to pool/main/p/postgresql-8.1/postgresql-doc-8.1_8.1.10-0etch1_all.deb postgresql-plperl-8.1_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/postgresql-plperl-8.1_8.1.10-0etch1_i386.deb postgresql-plpython-8.1_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/postgresql-plpython-8.1_8.1.10-0etch1_i386.deb postgresql-pltcl-8.1_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/postgresql-pltcl-8.1_8.1.10-0etch1_i386.deb postgresql-server-dev-8.1_8.1.10-0etch1_i386.deb to pool/main/p/postgresql-8.1/postgresql-server-dev-8.1_8.1.10-0etch1_i386.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Martin Pitt <[EMAIL PROTECTED]> (supplier of updated postgresql-8.1 package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.7 Date: Fri, 04 Jan 2008 13:30:54 +0100 Source: postgresql-8.1 Binary: postgresql-8.1 postgresql-pltcl-8.1 postgresql-plperl-8.1 libpgtypes2 libpq-dev libpq4 postgresql-doc-8.1 postgresql-plpython-8.1 libecpg5 libecpg-compat2 libecpg-dev postgresql-client-8.1 postgresql-contrib-8.1 postgresql-server-dev-8.1 Architecture: source all i386 Version: 8.1.10-0etch1 Distribution: stable Urgency: low Maintainer: Martin Pitt <[EMAIL PROTECTED]> Changed-By: Martin Pitt <[EMAIL PROTECTED]> Description: libecpg-compat2 - older version of run-time library for ECPG programs libecpg-dev - development files for ECPG (Embedded PostgreSQL for C) libecpg5 - run-time library for ECPG programs libpgtypes2 - shared library libpgtypes for PostgreSQL 8.1 libpq-dev - header files for libpq4 (PostgreSQL library) libpq4 - PostgreSQL C client library postgresql-8.1 - object-relational SQL database, version 8.1 server postgresql-client-8.1 - front-end programs for PostgreSQL 8.1 postgresql-contrib-8.1 - additional facilities for PostgreSQL postgresql-doc-8.1 - documentation for the PostgreSQL database management system postgresql-plperl-8.1 - PL/Perl procedural language for PostgreSQL 8.1 postgresql-plpython-8.1 - PL/Python procedural language for PostgreSQL 8.1 postgresql-pltcl-8.1 - PL/Tcl procedural language for PostgreSQL 8.1 postgresql-server-dev-8.1 - development files for PostgreSQL 8.1 server-side programming Closes: 443360 454637 458927 Changes: postgresql-8.1 (8.1.10-0etch1) stable; urgency=low . * New upstream bugfix release: - Require non-superusers who use "/contrib/dblink" to use only password authentication, as a security measure. [CVE-2007-3278, CVE-2007-3280] - Make "CREATE DOMAIN ... DEFAULT NULL" work properly. - Allow the interval data type to accept input consisting only of milliseconds or microseconds. - Speed up rtree index insertion. - Fix excessive logging of SSL error messages. - Fix logging so that log messages are never interleaved when using the syslogger process. - Fix crash when log_min_error_statement logging runs out of memory. - Fix incorrect handling of some foreign-key corner cases. - Prevent "REINDEX" and "CLUSTER" from failing due to attempting to process temporary tables of other sessions. - Update the time zone database rules, particularly New Zealand's upcoming changes. (Closes: #443360) * Drop debian/patches/00upstream-01-polymorphic-functions.patch, upstream now. * Use the timezone database from the system tzdata instead of shipping our own. (Closes: #458927, #454637) - debian/patches/04-timezone-symlinks.patch: Drop previous hardlink-to-symlink patch to zic, since that is irrelevant now. Replace the patch with a Makefile change that just symlinks /usr/share/zoneinfo to where postgresql previously installed its own tzdata copy. - debian/control: Add tzdata dependency. - debian/postgresql-8.1.install: Install the 'timezone' symlink, not the files in the dereferenced directory. - debian/postgresql-8.1.postinst: Replace the timezone directory with the symlink on upgrades, since dpkg does not do that automatically. Without this, we'd end up with an empty timezone directory. Files: c169e60ee2254d4fbda84d8638a3475c 1171 misc optional postgresql-8.1_8.1.10-0etch1.dsc f0e310ecf730bed0cceccaea77031a07 34613 misc optional postgresql-8.1_8.1.10-0etch1.diff.gz 099057a48c9c642e7a90defc04c95265 1582260 doc optional postgresql-doc-8.1_8.1.10-0etch1_all.deb 82f07a79d8b964832a5ff8e3ff31c1c2 326596 libdevel optional libpq-dev_8.1.10-0etch1_i386.deb feac6ca2fc661c5c32bf636fa51456ea 272346 libs optional libpq4_8.1.10-0etch1_i386.deb 9790bd8a7327bed897ed8e995f5590c8 181026 libs optional libecpg5_8.1.10-0etch1_i386.deb 8dee9785e6695f180c1426791fb41ac1 344886 libdevel optional libecpg-dev_8.1.10-0etch1_i386.deb 3c860a7b32fac9002ec49a3aa649c83a 160938 libs optional libecpg-compat2_8.1.10-0etch1_i386.deb 6e122b08bb03491145b50e6ec3171411 182926 libs optional libpgtypes2_8.1.10-0etch1_i386.deb 81c4bdf841485079be5b88bbaa406759 4281598 misc optional postgresql-8.1_8.1.10-0etch1_i386.deb 9e4813ff12c07821ef52ab9805c1977c 1407108 misc optional postgresql-client-8.1_8.1.10-0etch1_i386.deb d9af4ecef6f6d76d82c733c3f464abb2 607498 libdevel optional postgresql-server-dev-8.1_8.1.10-0etch1_i386.deb 915529882e3bd013667c9a6293c50f99 601734 misc optional postgresql-contrib-8.1_8.1.10-0etch1_i386.deb ef811be380de637e1466a98bfb7d5061 176498 misc optional postgresql-plperl-8.1_8.1.10-0etch1_i386.deb 50bb819d55fa113f95160e53ab944ae5 169648 misc optional postgresql-plpython-8.1_8.1.10-0etch1_i386.deb fefb8e2d11e737730a089338da3be518 171384 misc optional postgresql-pltcl-8.1_8.1.10-0etch1_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHf2TiDecnbV4Fd/IRAr4aAJ4gx7yC42kQnEyY4T7bDbuAZihGgQCeITs2 jTfMcujE+kncXbiLh9nAYFw= =5aYM -----END PGP SIGNATURE-----
--- End Message ---
