-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Sun, 25 Sep 2011 14:23:07 +0200 Source: postgresql-9.0 Binary: postgresql-9.0 postgresql-9.0-dbg postgresql-client-9.0 postgresql-server-dev-9.0 postgresql-doc-9.0 postgresql-contrib-9.0 postgresql-plperl-9.0 postgresql-plpython-9.0 postgresql-pltcl-9.0 Architecture: source all amd64 Version: 9.0.5-1 Distribution: unstable Urgency: low Maintainer: Martin Pitt <mpitt@debian.org> Changed-By: Martin Pitt <mpitt@debian.org> Description: postgresql-9.0 - object-relational SQL database, version 9.0 server postgresql-9.0-dbg - debug symbols for postgresql-9.0 postgresql-client-9.0 - front-end programs for PostgreSQL 9.0 postgresql-contrib-9.0 - additional facilities for PostgreSQL postgresql-doc-9.0 - documentation for the PostgreSQL database management system postgresql-plperl-9.0 - PL/Perl procedural language for PostgreSQL 9.0 postgresql-plpython-9.0 - PL/Python procedural language for PostgreSQL 9.0 postgresql-pltcl-9.0 - PL/Tcl procedural language for PostgreSQL 9.0 postgresql-server-dev-9.0 - development files for PostgreSQL 9.0 server-side programming Closes: 628505 636571 Changes: postgresql-9.0 (9.0.5-1) unstable; urgency=low . * New upstream bug fix release: - Fix catalog cache invalidation after a "VACUUM FULL" or "CLUSTER" on a system catalog. In some cases the relocation of a system catalog row to another place would not be recognized by concurrent server processes, allowing catalog corruption to occur if they then tried to update that row. The worst-case outcome could be as bad as complete loss of a table. - Fix incorrect order of operations during sinval reset processing, and ensure that TOAST OIDs are preserved in system catalogs. These mistakes could lead to transient failures after a "VACUUM FULL" or "CLUSTER" on a system catalog. - Fix bugs in indexing of in-doubt HOT-updated tuples. These bugs could result in index corruption after reindexing a system catalog. They are not believed to affect user indexes. - Fix multiple bugs in GiST index page split processing. - Fix possible buffer overrun in tsvector_concat(). - Fix crash in xml_recv when processing a "standalone" parameter. - Make pg_options_to_table return NULL for an option with no value. Previously such cases would result in a server crash. - Avoid possibly accessing off the end of memory in "ANALYZE" and in SJIS-2004 encoding conversion. This fixes some very-low-probability server crash scenarios. - Protect pg_stat_reset_shared() against NULL input. - Fix possible failure when a recovery conflict deadlock is detected within a sub-transaction. - Avoid spurious conflicts while recycling btree index pages during hot standby. - Shut down WAL receiver if it's still running at end of recovery. The postmaster formerly panicked in this situation, but it's actually a legitimate case. - Fix race condition in relcache init file invalidation. There was a window wherein a new backend process could read a stale init file but miss the inval messages that would tell it the data is stale. The result would be bizarre failures in catalog accesses, typically "could not read block 0 in file ..." later during startup. - Fix memory leak at end of a GiST index scan. - Fix memory leak when encoding conversion has to be done on incoming command strings and "LISTEN" is active. - Fix incorrect memory accounting (leading to possible memory bloat) in tuplestores supporting holdable cursors and plpgsql's RETURN NEXT command. - Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist. Evaluation of WHEN conditions for AFTER ROW UPDATE triggers could crash if there had been a BEFORE ROW trigger fired for the same update. - Fix performance problem when constructing a large, lossy bitmap. - Fix join selectivity estimation for unique columns. - Fix nested PlaceHolderVar expressions that appear only in sub-select target lists. This mistake could result in outputs of an outer join incorrectly appearing as NULL. - Allow the planner to assume that empty parent tables really are empty. Normally an empty table is assumed to have a certain minimum size for planning purposes; but this heuristic seems to do more harm than good for the parent table of an inheritance hierarchy, which often is permanently empty. - Allow nested EXISTS queries to be optimized properly. - Fix array- and path-creating functions to ensure padding bytes are zeroes. This avoids some situations where the planner will think that semantically-equal constants are not equal, resulting in poor optimization. - Fix "EXPLAIN" to handle gating Result nodes within inner-indexscan subplans. The usual symptom of this oversight was "bogus varno" errors. - Fix btree preprocessing of "indexedcol" IS NULL conditions. Such a condition is unsatisfiable if combined with any other type of btree-indexable condition on the same index column. The case was handled incorrectly in 9.0.0 and later, leading to query output where there should be none. - Work around gcc 4.6.0 bug that breaks WAL replay. This could lead to loss of committed transactions after a server crash. - Fix dump bug for VALUES in a view. - Disallow SELECT FOR UPDATE/SHARE on sequences. This operation doesn't work as expected and can lead to failures. - Fix "VACUUM" so that it always updates pg_class.reltuples/relpages. This fixes some scenarios where autovacuum could make increasingly poor decisions about when to vacuum tables. - Defend against integer overflow when computing size of a hash table. - Fix cases where "CLUSTER" might attempt to access already-removed TOAST data. - Fix premature timeout failures during initial authentication transaction. - Fix portability bugs in use of credentials control messages for "peer" authentication. (see #627596, already fixed in Debian before) - Fix SSPI login when multiple roundtrips are required. The typical symptom of this problem was "The function requested is not supported" errors during SSPI login. - Fix failure when adding a new variable of a custom variable class to "postgresql.conf". - Throw an error if "pg_hba.conf" contains hostssl but SSL is disabled. This was concluded to be more user-friendly than the previous behavior of silently ignoring such lines. - Fix failure when "DROP OWNED BY" attempts to remove default privileges on sequences. - Fix typo in pg_srand48 seed initialization. This led to failure to use all bits of the provided seed. This function is not used on most platforms (only those without srandom), and the potential security exposure from a less-random-than-expected seed seems minimal in any case. - Avoid integer overflow when the sum of LIMIT and OFFSET values exceeds 2^63. - Add overflow checks to int4 and int8 versions of generate_series() - Fix trailing-zero removal in to_char(). In a format with FM and no digit positions after the decimal point, zeroes to the left of the decimal point could be removed incorrectly. - Fix pg_size_pretty() to avoid overflow for inputs close to 2^63. - Weaken plpgsql's check for typmod matching in record values. An overly enthusiastic check could lead to discarding length modifiers that should have been kept. - In pg_upgrade, avoid dumping orphaned temporary tables. This prevents situations wherein table OID assignments could get out of sync between old and new installations. - Fix pg_upgrade to preserve toast tables' relfrozenxids during an upgrade from 8.3. Failure to do this could lead to "pg_clog" files being removed too soon after the upgrade. - Fix psql's counting of script file line numbers during COPY from a different file. - Fix pg_restore's direct-to-database mode for standard_conforming_strings. pg_restore could emit incorrect commands when restoring directly to a database server from an archive file that had been made with standard_conforming_strings set to on. - Be more user-friendly about unsupported cases for parallel pg_restore. This change ensures that such cases are detected and reported before any restore actions have been taken. - Fix write-past-buffer-end and memory leak in libpq's LDAP service lookup code. - In libpq, avoid failures when using nonblocking I/O and an SSL connection. - Improve libpq's handling of failures during connection startup. In particular, the response to a server report of fork() failure during SSL connection startup is now saner. - Improve libpq's error reporting for SSL failures. - Fix PQsetvalue() to avoid possible crash when adding a new tuple to a PGresult originally obtained from a server query. - Make ecpglib write double values with 15 digits precision. - In ecpglib, be sure LC_NUMERIC setting is restored after an error. - Apply upstream fix for blowfish signed-character bug (CVE-2011-2483) (Tom Lane) (Closes: #636571) "contrib/pg_crypto"'s blowfish encryption code could give wrong results on platforms where char is signed (which is most), leading to encrypted passwords being weaker than they should be. - Fix memory leak in "contrib/seg". - Fix pgstatindex() to give consistent results for empty indexes. - Allow building with perl 5.14. (Closes: #628505) * Drop 03-cmsgcred-size.patch. Fixed upstream in a different way. Checksums-Sha1: 121572b5cbf38661d1ed96f3dcce4610c1656155 2356 postgresql-9.0_9.0.5-1.dsc 1c71be5b1a7d519eff33bb60768776f47b44acf3 14344752 postgresql-9.0_9.0.5.orig.tar.bz2 1f4f4af116b2be94ddc5f131c86e8f8a824385f0 25617 postgresql-9.0_9.0.5-1.debian.tar.gz 67530a979d99713c5785735f26a65135d974dba9 2607992 postgresql-doc-9.0_9.0.5-1_all.deb e93c2eaf4fd16ed5d136a16d4ca6a72aad93afec 6042842 postgresql-9.0_9.0.5-1_amd64.deb 80f4adf2cdddce862f9847d983e56a45efd8f25a 7787756 postgresql-9.0-dbg_9.0.5-1_amd64.deb aea9820d6415e6f217f8f2265a3a76fd3396d465 1795598 postgresql-client-9.0_9.0.5-1_amd64.deb cbcd237b2e7c0a1c9f50469e44635cb0cafb1ab9 974810 postgresql-server-dev-9.0_9.0.5-1_amd64.deb 345aedc050627b74646814253676f3fab3d16259 769576 postgresql-contrib-9.0_9.0.5-1_amd64.deb f6c47b2161b7410466f4db208c6ee90d17507bf8 380820 postgresql-plperl-9.0_9.0.5-1_amd64.deb 0d35a77940e8f7b54e0348ee84abda0b044be014 382044 postgresql-plpython-9.0_9.0.5-1_amd64.deb 7b20dd741657f2685a1dc2012bd9619fc925083e 354938 postgresql-pltcl-9.0_9.0.5-1_amd64.deb Checksums-Sha256: 577f416fb63f88f7dece1c0894a24b5e3383c9960b4971cd395c400497aed7ba 2356 postgresql-9.0_9.0.5-1.dsc 56d8ee809ceeabeae8461ae0a197943460cba5bf8fbe37324e4451cf2eb7d504 14344752 postgresql-9.0_9.0.5.orig.tar.bz2 de69a4d7f670bddadb7848055a77f29ff48eb99c267943df64a83f5910e27682 25617 postgresql-9.0_9.0.5-1.debian.tar.gz c8e7ac1bdaead0b8423a4e3edb64be67d4116a1318ec199415ccb33c72e09b50 2607992 postgresql-doc-9.0_9.0.5-1_all.deb 466b9e7e81bb1ba7c0e7149f891814f1cac34fd3d9072a69674f5f415288b5f9 6042842 postgresql-9.0_9.0.5-1_amd64.deb ba8e62652dd0d344c7204c3f43b2ea754c3d5b48a73c6674f9873bd70001385d 7787756 postgresql-9.0-dbg_9.0.5-1_amd64.deb ac2d45f9d7f499cc2ee55750f0c5c8f0047f6bd323b3b3430d1717ea0b845b2d 1795598 postgresql-client-9.0_9.0.5-1_amd64.deb ea9704033d2b60cf7cbe3f761bc834e61d6acabe97d4afc8843f41826eefda88 974810 postgresql-server-dev-9.0_9.0.5-1_amd64.deb f88d86165c34b7164a1f7ed4e552ef0ba3a230513765c13ee0a0fe7679bd2293 769576 postgresql-contrib-9.0_9.0.5-1_amd64.deb 01247b57df31989c042a85e7179c2aee9955031aa686d5cefe17a8dffb068029 380820 postgresql-plperl-9.0_9.0.5-1_amd64.deb 225033e3fdf436e4207d5e59898c9a438b0d0d2885cba5eb3cafa5f11ff4157a 382044 postgresql-plpython-9.0_9.0.5-1_amd64.deb ab0cb8a9ac03b86f040f7db9d089bda395387ab9e9011ce2ababe11416873c26 354938 postgresql-pltcl-9.0_9.0.5-1_amd64.deb Files: 531a3097ab86539aa6ca918c92dc6025 2356 database optional postgresql-9.0_9.0.5-1.dsc 86816eb8a8513532957b96045abdfef9 14344752 database optional postgresql-9.0_9.0.5.orig.tar.bz2 114875c3dad80797b620e7345568ec10 25617 database optional postgresql-9.0_9.0.5-1.debian.tar.gz fd968a707b2bf32f1c480db553cc6a73 2607992 doc optional postgresql-doc-9.0_9.0.5-1_all.deb 8717dc245eddf88c6b273386eee0885a 6042842 database optional postgresql-9.0_9.0.5-1_amd64.deb fc2eb52d42cdaec3c3cb573a9dfa4fcc 7787756 debug extra postgresql-9.0-dbg_9.0.5-1_amd64.deb 765993c6d2e0b3dce537987319e5d0d7 1795598 database optional postgresql-client-9.0_9.0.5-1_amd64.deb daf2942a0cfe76b424400bc803fd90a8 974810 libdevel optional postgresql-server-dev-9.0_9.0.5-1_amd64.deb 4aca95eeeee3db679dd085211c42c5a7 769576 database optional postgresql-contrib-9.0_9.0.5-1_amd64.deb 2237a24728b293751cbf273257f6328d 380820 database optional postgresql-plperl-9.0_9.0.5-1_amd64.deb 09c22e75846281739bd4e728882bf8ea 382044 database optional postgresql-plpython-9.0_9.0.5-1_amd64.deb 9a29432b735f5603716ea3fbc3eb7753 354938 database optional postgresql-pltcl-9.0_9.0.5-1_amd64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQIcBAEBCAAGBQJOfx7WAAoJEPmIJawmtHuf7P8P/3Z1WM3dQ5EspRIvspgg+0bW kRWYLwvbkvQkhAT6qwiViwqvb9P0Hj3t9OA1pz9WLDOVu2DN/ct8bRtSZXGyzXWF yXc80D56gjCck/KzRSS2mPtiDxvBkEhgURmEZlioX7zIfM3648e9Xa2l1Z3kknAU zYoOeRtuEXw8Ogw6CWjvPW9X5U7SVdymOgUuF4qF67k9dygSu8N01xhdK42a7jxP a9I57/Ffj7+SP+mkHivfIXdnxKpCCS0AoXxw32Savx3b78BMU6i3FKvULovfN7Kz scjGHQaLQmjmb/3Jzs7K4E8prIEH3MmbU2R70VnNfCRn0EXPH8Hgi/B9Vtsib/TU AIBLE6HWP5mCPf/B0+L3MBIM+3XG67I/reDV8uWNkPuFLV9Qywg3fmF3SENvqLgP xy1IsN5KlhD1lOdlapQ/ekPqFqecd+nmCBwT5h2RBQtnZVnu5SGJUd5ZusTS4/bw nxwcPUMnohf4j55D06xtFL7Vq5pKf+eSqnnMWKNGb5WCnVlpuQhNa8kSBQRpoAU0 P92Ebr46zBZEKXWt6tJ0nvxP+yf54Ddj4Of9AowlF7DIdNkW6/96V2IqtXmrJTor 01T2l0hTCUnrYTWVorPoCzMWOACnkCKHmOs3TaMv6/KW24Zg4KNUEyJX4fobdmok UXAgOx+BZjM5GUPO/UFe =ufYY -----END PGP SIGNATURE----- Accepted: postgresql-9.0-dbg_9.0.5-1_amd64.deb to main/p/postgresql-9.0/postgresql-9.0-dbg_9.0.5-1_amd64.deb postgresql-9.0_9.0.5-1.debian.tar.gz to main/p/postgresql-9.0/postgresql-9.0_9.0.5-1.debian.tar.gz postgresql-9.0_9.0.5-1.dsc to main/p/postgresql-9.0/postgresql-9.0_9.0.5-1.dsc postgresql-9.0_9.0.5-1_amd64.deb to main/p/postgresql-9.0/postgresql-9.0_9.0.5-1_amd64.deb postgresql-9.0_9.0.5.orig.tar.bz2 to main/p/postgresql-9.0/postgresql-9.0_9.0.5.orig.tar.bz2 postgresql-client-9.0_9.0.5-1_amd64.deb to main/p/postgresql-9.0/postgresql-client-9.0_9.0.5-1_amd64.deb postgresql-contrib-9.0_9.0.5-1_amd64.deb to main/p/postgresql-9.0/postgresql-contrib-9.0_9.0.5-1_amd64.deb postgresql-doc-9.0_9.0.5-1_all.deb to main/p/postgresql-9.0/postgresql-doc-9.0_9.0.5-1_all.deb postgresql-plperl-9.0_9.0.5-1_amd64.deb to main/p/postgresql-9.0/postgresql-plperl-9.0_9.0.5-1_amd64.deb postgresql-plpython-9.0_9.0.5-1_amd64.deb to main/p/postgresql-9.0/postgresql-plpython-9.0_9.0.5-1_amd64.deb postgresql-pltcl-9.0_9.0.5-1_amd64.deb to main/p/postgresql-9.0/postgresql-pltcl-9.0_9.0.5-1_amd64.deb postgresql-server-dev-9.0_9.0.5-1_amd64.deb to main/p/postgresql-9.0/postgresql-server-dev-9.0_9.0.5-1_amd64.deb