Your message dated Thu, 17 Jan 2008 19:52:16 +0000
with message-id <[EMAIL PROTECTED]>
and subject line Bug#454637: 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
As of 2007-12-09 07:00:00 UTC, Venezuela will shift from -4:00 to -4:30.
The version of PostgreSQL currently available in Debian Etch does not
handle it correctly making date manipulation unaccurate.
Attached a patch that fixes the problem. I placed the patch in
debian/patches, rebuilt the whole thing, ran the regression tests and
specifically tested the timezone related calculations and they work
fine.
--
Ernesto Hernández-Novich - Linux 2.6.18 i686 - Unix: Live free or die!
Geek by nature, Linux by choice, Debian of course.
If you can't aptitude it, it isn't useful or doesn't exist.
GPG Key Fingerprint = 438C 49A2 A8C7 E7D7 1500 C507 96D6 A3D6 2F4C 85E3
diff -ruN postgresql-8.1.9/src/timezone/data/southamerica postgresql-8.1.9-old/src/timezone/data/southamerica
--- postgresql-8.1.9/src/timezone/data/southamerica 2007-04-19 18:44:44.000000000 -0400
+++ postgresql-8.1.9-old/src/timezone/data/southamerica 2007-12-06 14:55:51.024121641 -0400
@@ -1101,4 +1101,5 @@
Zone America/Caracas -4:27:44 - LMT 1890
-4:27:40 - CMT 1912 Feb 12 # Caracas Mean Time?
-4:30 - VET 1965 # Venezuela Time
- -4:00 - VET
+ -4:00 - VET 2007 Dec 09 03:00
+ -4:30 - VET
--- 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 ---
