-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Mon, 04 Jun 2012 06:47:45 +0200 Source: postgresql-9.1 Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-9.1 postgresql-9.1-dbg postgresql-client-9.1 postgresql-server-dev-9.1 postgresql-doc-9.1 postgresql-contrib-9.1 postgresql-plperl-9.1 postgresql-plpython-9.1 postgresql-plpython3-9.1 postgresql-pltcl-9.1 Architecture: source amd64 all Version: 9.1.4-1 Distribution: unstable Urgency: medium Maintainer: Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org> Changed-By: Martin Pitt <mpitt@debian.org> Description: libecpg-compat3 - older version of run-time library for ECPG programs libecpg-dev - development files for ECPG (Embedded PostgreSQL for C) libecpg6 - run-time library for ECPG programs libpgtypes3 - shared library libpgtypes for PostgreSQL 9.1 libpq-dev - header files for libpq5 (PostgreSQL library) libpq5 - PostgreSQL C client library postgresql-9.1 - object-relational SQL database, version 9.1 server postgresql-9.1-dbg - debug symbols for postgresql-9.1 postgresql-client-9.1 - front-end programs for PostgreSQL 9.1 postgresql-contrib-9.1 - additional facilities for PostgreSQL postgresql-doc-9.1 - documentation for the PostgreSQL database management system postgresql-plperl-9.1 - PL/Perl procedural language for PostgreSQL 9.1 postgresql-plpython-9.1 - PL/Python procedural language for PostgreSQL 9.1 postgresql-plpython3-9.1 - PL/Python 3 procedural language for PostgreSQL 9.1 postgresql-pltcl-9.1 - PL/Tcl procedural language for PostgreSQL 9.1 postgresql-server-dev-9.1 - development files for PostgreSQL 9.1 server-side programming Changes: postgresql-9.1 (9.1.4-1) unstable; urgency=medium . * Urgency medium due to security fixes. * New upstream bug fix/security release: - Fix incorrect password transformation in "contrib/pgcrypto"'s DES crypt() function. If a password string contained the byte value 0x80, the remainder of the password was ignored, causing the password to be much weaker than it appeared. With this fix, the rest of the string is properly included in the DES hash. Any stored password values that are affected by this bug will thus no longer match, so the stored values may need to be updated. (CVE-2012-2143) - Ignore SECURITY DEFINER and SET attributes for a procedural language's call handler. Applying such attributes to a call handler could crash the server. (CVE-2012-2655) - Make "contrib/citext"'s upgrade script fix collations of citext arrays and domains over citext. Release 9.1.2 provided a fix for collations of citext columns and indexes in databases upgraded or reloaded from pre-9.1 installations, but that fix was incomplete: it neglected to handle arrays and domains over citext. This release extends the module's upgrade script to handle these cases. As before, if you have already run the upgrade script, you'll need to run the collation update commands by hand instead. See the 9.1.2 release notes for more information about doing this. - Allow numeric timezone offsets in timestamp input to be up to 16 hours away from UTC. Some historical time zones have offsets larger than 15 hours, the previous limit. This could result in dumped data values being rejected during reload. - Fix timestamp conversion to cope when the given time is exactly the last DST transition time for the current timezone. This oversight has been there a long time, but was not noticed previously because most DST-using zones are presumed to have an indefinite sequence of future DST transitions. - Fix text to name and char to name casts to perform string truncation correctly in multibyte encodings. - Fix memory copying bug in to_tsquery(). - Ensure txid_current() reports the correct epoch when executed in hot standby. - Fix planner's handling of outer PlaceHolderVars within subqueries. This bug concerns sub-SELECTs that reference variables coming from the nullable side of an outer join of the surrounding query. In 9.1, queries affected by this bug would fail with "ERROR: Upper-level PlaceHolderVar found where not expected". But in 9.0 and 8.4, you'd silently get possibly-wrong answers, since the value transmitted into the subquery wouldn't go to null when it should. - Fix planning of UNION ALL subqueries with output columns that are not simple variables. Planning of such cases got noticeably worse in 9.1 as a result of a misguided fix for "MergeAppend child's targetlist doesn't match MergeAppend" errors. Revert that fix and do it another way. - Fix slow session startup when pg_attribute is very large. If pg_attribute exceeds one-fourth of shared_buffers, cache rebuilding code that is sometimes needed during session start would trigger the synchronized-scan logic, causing it to take many times longer than normal. The problem was particularly acute if many new sessions were starting at once. - Ensure sequential scans check for query cancel reasonably often. A scan encountering many consecutive pages that contain no live tuples would not respond to interrupts meanwhile. - Ensure the Windows implementation of PGSemaphoreLock() clears ImmediateInterruptOK before returning. This oversight meant that a query-cancel interrupt received later in the same query could be accepted at an unsafe time, with unpredictable but not good consequences. - Show whole-row variables safely when printing views or rules. Corner cases involving ambiguous names (that is, the name could be either a table or column name of the query) were printed in an ambiguous way, risking that the view or rule would be interpreted differently after dump and reload. Avoid the ambiguous case by attaching a no-op cast. - Fix "COPY FROM" to properly handle null marker strings that correspond to invalid encoding. A null marker string such as E'\\0' should work, and did work in the past, but the case got broken in 8.4. - Fix "EXPLAIN VERBOSE" for writable CTEs containing RETURNING clauses. - Fix "PREPARE TRANSACTION" to work correctly in the presence of advisory locks. Historically, "PREPARE TRANSACTION" has simply ignored any session-level advisory locks the session holds, but this case was accidentally broken in 9.1. - Fix truncation of unlogged tables. - Ignore missing schemas during non-interactive assignments of search_path. This re-aligns 9.1's behavior with that of older branches. Previously 9.1 would throw an error for nonexistent schemas mentioned in search_path settings obtained from places such as "ALTER DATABASE SET". - Fix bugs with temporary or transient tables used in extension scripts. This includes cases such as a rewriting "ALTER TABLE" within an extension update script, since that uses a transient table behind the scenes. - Ensure autovacuum worker processes perform stack depth checking properly. Previously, infinite recursion in a function invoked by auto-"ANALYZE" could crash worker processes. - Fix logging collector to not lose log coherency under high load. The collector previously could fail to reassemble large messages if it got too busy. - Fix logging collector to ensure it will restart file rotation after receiving SIGHUP. - Fix "too many LWLocks taken" failure in GiST indexes. - Fix WAL replay logic for GIN indexes to not fail if the index was subsequently dropped. - Correctly detect SSI conflicts of prepared transactions after a crash. - Avoid synchronous replication delay when committing a transaction that only modified temporary tables. In such a case the transaction's commit record need not be flushed to standby servers, but some of the code didn't know that and waited for it to happen anyway. - Fix error handling in pg_basebackup. - Fix walsender to not go into a busy loop if connection is terminated. - Fix memory leak in PL/pgSQL's "RETURN NEXT" command. - Fix PL/pgSQL's "GET DIAGNOSTICS" command when the target is the function's first variable. - Ensure that PL/Perl package-qualifies the _TD variable. This bug caused trigger invocations to fail when they are nested within a function invocation that changes the current package. - Fix PL/Python functions returning composite types to accept a string for their result value. This case was accidentally broken by the 9.1 additions to allow a composite result value to be supplied in other formats, such as dictionaries. - Fix potential access off the end of memory in psql's expanded display ("\x") mode. - Fix several performance problems in pg_dump when the database contains many objects. pg_dump could get very slow if the database contained many schemas, or if many objects are in dependency loops, or if there are many owned sequences. - Fix memory and file descriptor leaks in pg_restore when reading a directory-format archive. - Fix pg_upgrade for the case that a database stored in a non-default tablespace contains a table in the cluster's default tablespace. - In ecpg, fix rare memory leaks and possible overwrite of one byte after the sqlca_t structure. - Fix "contrib/dblink"'s dblink_exec() to not leak temporary database connections upon error. - Fix "contrib/dblink" to report the correct connection name in error messages. - Fix "contrib/vacuumlo" to use multiple transactions when dropping many large objects. This change avoids exceeding max_locks_per_transaction when many objects need to be dropped. The behavior can be adjusted with the new -l (limit) option. * debian/control: Bump debhelper build dependency to >= 8, as it does not build with earlier versions. * debian/control: Move bzr branches to alioth, so that other members of pkg-postgresql can commit. Update Vcs-* tags. * debian/control: Set Maintainer: to pkg-postgresql group, and move myself to Uploaders:. Checksums-Sha1: 0cdb934ffe224d03184e79353330bacebd209a05 3253 postgresql-9.1_9.1.4-1.dsc c75fd5696af02a275a104260eac8b3a4abe35682 15631894 postgresql-9.1_9.1.4.orig.tar.bz2 462f5f77942827f7390d8ff0d7e19c80e2e390ad 32905 postgresql-9.1_9.1.4-1.debian.tar.gz 983e79b9becece46b5ba58d009278e0a73e93e95 612026 libpq-dev_9.1.4-1_amd64.deb 21d669ff9861cb5d74bd738558daac125bb7683e 526374 libpq5_9.1.4-1_amd64.deb 84456d571b3d3a0640bd1beb3e471fa88713c667 471888 libecpg6_9.1.4-1_amd64.deb 0717478e82488daff43f022c425bf5327d48e7d6 639102 libecpg-dev_9.1.4-1_amd64.deb 9d638aa602bb9393820cc88ac49172399e86ce2c 388960 libecpg-compat3_9.1.4-1_amd64.deb e678a5e416d6a7a2d041f57819428829469a32cc 413078 libpgtypes3_9.1.4-1_amd64.deb 9a5c0636f3eabb16bdd94bd338217f4226f6f9b5 6286650 postgresql-9.1_9.1.4-1_amd64.deb 100c590d98b2b204a6e8015004283979b6d5f943 11352238 postgresql-9.1-dbg_9.1.4-1_amd64.deb 578ba097b4d7ede0828a04fa38f2efa55f024945 1951604 postgresql-client-9.1_9.1.4-1_amd64.deb 97c06837a22f79fe1b77d4dc90697358c3f71e99 1055346 postgresql-server-dev-9.1_9.1.4-1_amd64.deb 8c81a7c8f54fccc3001266cc885883c7248fb92f 2928692 postgresql-doc-9.1_9.1.4-1_all.deb 0f06f4969dc86cd8b653d0c789bd942f1260b8a0 851256 postgresql-contrib-9.1_9.1.4-1_amd64.deb 39f23ef1e12e123a2b15005507821b112e2c1d0c 436690 postgresql-plperl-9.1_9.1.4-1_amd64.deb 358a81564ce49fffd52123bd049578625a9a393e 419588 postgresql-plpython-9.1_9.1.4-1_amd64.deb 89eaeb605605071750dea69bb618e0f676353323 419370 postgresql-plpython3-9.1_9.1.4-1_amd64.deb 4f1dc5ebab79ad8dcfd5174dc503b9bb654373fc 405994 postgresql-pltcl-9.1_9.1.4-1_amd64.deb Checksums-Sha256: 89f35141930a0891250861534b4f63108475a9f980c661d01daf4f0b5a20e390 3253 postgresql-9.1_9.1.4-1.dsc a0795a8eb3ae2d1a2914b63bf143d20182835d90699915ff43567c041d3c9712 15631894 postgresql-9.1_9.1.4.orig.tar.bz2 accde0f2d4b12c8e24541a2fbfc45b7b8a084a6f80ec6a4b8559d832b66686b4 32905 postgresql-9.1_9.1.4-1.debian.tar.gz 6ce2bb888e6002369497f02b63ac2f0c483036b07a9579c4ae83ae4868ddf712 612026 libpq-dev_9.1.4-1_amd64.deb 0aa1341fb00bbe0eb4820b05296e94358b28877a54ccf029952b11d944ffab60 526374 libpq5_9.1.4-1_amd64.deb 95573afffc717ae4ce1a48bde2c9f9a98ddc62aaf9f1c18925fd2eaf6402cbdd 471888 libecpg6_9.1.4-1_amd64.deb badef494fdacaa481c610c3565a626e13ea09105e9c4d17b9384128543a4d7b3 639102 libecpg-dev_9.1.4-1_amd64.deb fbf471430a8e8f5a07bfc7faa624e21443458aa1036cd9e9fdb98e43b76afafc 388960 libecpg-compat3_9.1.4-1_amd64.deb 97428d8b13ab728b7b38ec4210c8c2473aea7463beb1de71c0dacdb2c3ea6437 413078 libpgtypes3_9.1.4-1_amd64.deb 88fb7fc5c3729017cedf5a7f72c2abbdaf6b0d9c3341ef8f2ceaf6e6650a9bd2 6286650 postgresql-9.1_9.1.4-1_amd64.deb 3102de70b27887b555d7ee8d9aa277d7ac6cc389e4e08ccfe6812ce71ec2a2f6 11352238 postgresql-9.1-dbg_9.1.4-1_amd64.deb 35c1aa8bc03c2f50f5f42aad1cc70aee6fd7b1e071c04b0c377527d9d90e5386 1951604 postgresql-client-9.1_9.1.4-1_amd64.deb e0c4dd43c8af07c0258b436cc58f58e850266bad97d71f82356342136b0035b9 1055346 postgresql-server-dev-9.1_9.1.4-1_amd64.deb 078604c3ebab694d816293bb83fa47e7cd24ff345510cb944ab6f6b296199382 2928692 postgresql-doc-9.1_9.1.4-1_all.deb ce83d6c9fc2291ce135f2d9c34135dc0eac21a7609414c6a841b20dfdf0f4961 851256 postgresql-contrib-9.1_9.1.4-1_amd64.deb f6c9ff73ffabe33588c218fe74375dfb79eaeb4997d575f383de5cab191506b3 436690 postgresql-plperl-9.1_9.1.4-1_amd64.deb e1f4e855921943816bf1430af76d9e94c41b51c7afd3e0336f3738fe502881a5 419588 postgresql-plpython-9.1_9.1.4-1_amd64.deb cdd57d8753c1301d2a5053f23dee4cc5cfe263989e5f57a0cc466d2424399d83 419370 postgresql-plpython3-9.1_9.1.4-1_amd64.deb 17548415df2c3c49d9c8ca7d33aff8436b41afe5ae624e2b17232d82c08aec09 405994 postgresql-pltcl-9.1_9.1.4-1_amd64.deb Files: 0c9e024ac55ce8cc965996d90b828d12 3253 database optional postgresql-9.1_9.1.4-1.dsc a8035688dba988b782725ac1aec60186 15631894 database optional postgresql-9.1_9.1.4.orig.tar.bz2 f1c4af446c72fa23ec30d039b4f12fe5 32905 database optional postgresql-9.1_9.1.4-1.debian.tar.gz 7d936f9592a2e14101729609c9d8c220 612026 libdevel optional libpq-dev_9.1.4-1_amd64.deb b25d65621df33032c43a5cf469ffe402 526374 libs optional libpq5_9.1.4-1_amd64.deb dd304bb6d66685b63f2905a16ff3fe9e 471888 libs optional libecpg6_9.1.4-1_amd64.deb 210a093d09ca9d09952f48ec8adae4c0 639102 libdevel optional libecpg-dev_9.1.4-1_amd64.deb 1b1fe092eb65c13885894ce40a9bdbcb 388960 libs optional libecpg-compat3_9.1.4-1_amd64.deb 4aeb35d7bf74d7202ce758aeaa34f557 413078 libs optional libpgtypes3_9.1.4-1_amd64.deb e83a04dc60253f9a8bfeb4a48f505edb 6286650 database optional postgresql-9.1_9.1.4-1_amd64.deb 900ec9f0c4fa3ea2890c3b59f57773e8 11352238 debug extra postgresql-9.1-dbg_9.1.4-1_amd64.deb 62af49f68750fcc6ebc2e84f9c9239d0 1951604 database optional postgresql-client-9.1_9.1.4-1_amd64.deb 86f61d6113f63d02d040984730acb2bb 1055346 libdevel optional postgresql-server-dev-9.1_9.1.4-1_amd64.deb 55718c3953ea5a33d34e6cc45d675d87 2928692 doc optional postgresql-doc-9.1_9.1.4-1_all.deb 1b6c2a02950ebaac5faaac3548075420 851256 database optional postgresql-contrib-9.1_9.1.4-1_amd64.deb 6c82b7b6ba6672002a23d5d2a0665428 436690 database optional postgresql-plperl-9.1_9.1.4-1_amd64.deb fbbec2e12deb9c4eec5e010db7b80abc 419588 database optional postgresql-plpython-9.1_9.1.4-1_amd64.deb bbd7a7a85b7f100654597d6ff56b1129 419370 database optional postgresql-plpython3-9.1_9.1.4-1_amd64.deb 34841258e8dfd38d268dd13c89469f61 405994 database optional postgresql-pltcl-9.1_9.1.4-1_amd64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBCAAGBQJPzEbvAAoJEPmIJawmtHufGSIP/1LEL+ftdrhJnDCUozeUyO7M phYbJYJgsSM2N/CnWyYqyjEaT4nxBvFgMmpul+bYOkE5OijTumBIhdQW3ytxmpHy sVSwe7hIZS4P/SXtEazPK7q4fi30iKjB4ziFxXE+Db7QgM8BxEG3Ed4Guoml2Ih5 2HfXGxCg+qbnIIlTwxFgb+3rLLHVHKyKmhabm7SGGuB2XI4AJBo/ymqTgcVymje2 N8BnjU0hyeFOh48A+BPGAK6qGwuF4cHlYKJuieZxpeQx6OGupgBIlRZfQMaiHDIj 8pVAbhNlTDhOCWXHutNMjaq1fBvjd8zSdPRFi6Zt045kcn2zrKUmtcDPzOfs/tOi juE7l3m1LPg4O4L8PwwRJ7XeqTPXOr1kRaqYexhXntZSngptQMH3yeGPrN69RfJi kh3zQjJuN11BaYS2OwzbzsfHAcbv5rIibwJDM3FIuPo2l8EgH0SM2w6RCTeBrtIK 0QBYTtMdIh111fLrLA9gn45Xi+T67lKJ2ye+EK9JPnMdu2bokDxxC3ZCQZep+y/7 xaJF6EXeZICdYlrom65TZSFl0YQ2Z9exxJs/CHYiCHltJ74dLJDlqgm9q1u1gLaN Et68Fp4nzkTQaeiLvulnDHxj8wmhwkJZQ/hTPIQt3cv/HPqVMyHaDXm9ri64hXzx NX8dZJNzBOZLmkE4qT8h =PaIS -----END PGP SIGNATURE----- Accepted: libecpg-compat3_9.1.4-1_amd64.deb to main/p/postgresql-9.1/libecpg-compat3_9.1.4-1_amd64.deb libecpg-dev_9.1.4-1_amd64.deb to main/p/postgresql-9.1/libecpg-dev_9.1.4-1_amd64.deb libecpg6_9.1.4-1_amd64.deb to main/p/postgresql-9.1/libecpg6_9.1.4-1_amd64.deb libpgtypes3_9.1.4-1_amd64.deb to main/p/postgresql-9.1/libpgtypes3_9.1.4-1_amd64.deb libpq-dev_9.1.4-1_amd64.deb to main/p/postgresql-9.1/libpq-dev_9.1.4-1_amd64.deb libpq5_9.1.4-1_amd64.deb to main/p/postgresql-9.1/libpq5_9.1.4-1_amd64.deb postgresql-9.1-dbg_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-9.1-dbg_9.1.4-1_amd64.deb postgresql-9.1_9.1.4-1.debian.tar.gz to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1.debian.tar.gz postgresql-9.1_9.1.4-1.dsc to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1.dsc postgresql-9.1_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1_amd64.deb postgresql-9.1_9.1.4.orig.tar.bz2 to main/p/postgresql-9.1/postgresql-9.1_9.1.4.orig.tar.bz2 postgresql-client-9.1_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-client-9.1_9.1.4-1_amd64.deb postgresql-contrib-9.1_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-contrib-9.1_9.1.4-1_amd64.deb postgresql-doc-9.1_9.1.4-1_all.deb to main/p/postgresql-9.1/postgresql-doc-9.1_9.1.4-1_all.deb postgresql-plperl-9.1_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-plperl-9.1_9.1.4-1_amd64.deb postgresql-plpython-9.1_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-plpython-9.1_9.1.4-1_amd64.deb postgresql-plpython3-9.1_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-plpython3-9.1_9.1.4-1_amd64.deb postgresql-pltcl-9.1_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-pltcl-9.1_9.1.4-1_amd64.deb postgresql-server-dev-9.1_9.1.4-1_amd64.deb to main/p/postgresql-9.1/postgresql-server-dev-9.1_9.1.4-1_amd64.deb