Format: 1.8 Date: Tue, 21 Dec 2010 21:17:08 +0100 Source: postgresql-8.4 Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-8.4 postgresql-client-8.4 postgresql-server-dev-8.4 postgresql-doc-8.4 postgresql-contrib-8.4 postgresql-plperl-8.4 postgresql-plpython-8.4 postgresql-pltcl-8.4 postgresql postgresql-client postgresql-doc postgresql-contrib Architecture: armel armel_translations Version: 8.4.6-0ubuntu9.10 Distribution: karmic-proposed Urgency: low Maintainer: Ubuntu/armel Build Daemon Changed-By: Martin Pitt 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 8.4 libpq-dev - header files for libpq5 (PostgreSQL library) libpq5 - PostgreSQL C client library postgresql - object-relational SQL database (supported version) postgresql-8.4 - object-relational SQL database, version 8.4 server postgresql-client - front-end programs for PostgreSQL (supported version) postgresql-client-8.4 - front-end programs for PostgreSQL 8.4 postgresql-contrib - additional facilities for PostgreSQL (supported version) postgresql-contrib-8.4 - additional facilities for PostgreSQL postgresql-doc - documentation for the PostgreSQL database management system postgresql-doc-8.4 - documentation for the PostgreSQL database management system postgresql-plperl-8.4 - PL/Perl procedural language for PostgreSQL 8.4 postgresql-plpython-8.4 - PL/Python procedural language for PostgreSQL 8.4 postgresql-pltcl-8.4 - PL/Tcl procedural language for PostgreSQL 8.4 postgresql-server-dev-8.4 - development files for PostgreSQL 8.4 server-side programming Changes: postgresql-8.4 (8.4.6-0ubuntu9.10) karmic-proposed; urgency=low . * New upstream bug fix release: (LP: #693157) - Force the default wal_sync_method to be fdatasync on Linux. The default on Linux has actually been fdatasync for many years, but recent kernel changes caused PostgreSQL to choose open_datasync instead. This choice did not result in any performance improvement, and caused outright failures on certain filesystems, notably ext4 with the data=journal mount option. - Fix assorted bugs in WAL replay logic for GIN indexes. This could result in "bad buffer id: 0" failures or corruption of index contents during replication. - Fix recovery from base backup when the starting checkpoint WAL record is not in the same WAL segment as its redo point. - Fix persistent slowdown of autovacuum workers when multiple workers remain active for a long time. The effective vacuum_cost_limit for an autovacuum worker could drop to nearly zero if it processed enough tables, causing it to run extremely slowly. - Add support for detecting register-stack overrun on IA64. The IA64 architecture has two hardware stacks. Full prevention of stack-overrun failures requires checking both. - Add a check for stack overflow in copyObject(). Certain code paths could crash due to stack overflow given a sufficiently complex query. - Fix detection of page splits in temporary GiST indexes. It is possible to have a "concurrent" page split in a temporary index, if for example there is an open cursor scanning the index when an insertion is done. GiST failed to detect this case and hence could deliver wrong results when execution of the cursor continued. - Fix error checking during early connection processing. The check for too many child processes was skipped in some cases, possibly leading to postmaster crash when attempting to add the new child process to fixed-size arrays. - Improve efficiency of window functions. Certain cases where a large number of tuples needed to be read in advance, but work_mem was large enough to allow them all to be held in memory, were unexpectedly slow. percent_rank(), cume_dist() and ntile() in particular were subject to this problem. - Avoid memory leakage while "ANALYZE"'ing complex index expressions. - Ensure an index that uses a whole-row Var still depends on its table. An index declared like create index i on t (foo(t.-)) would not automatically get dropped when its table was dropped. - Do not "inline" a SQL function with multiple OUT parameters. This avoids a possible crash due to loss of information about the expected result rowtype. - Behave correctly if ORDER BY, LIMIT, FOR UPDATE, or WITH is attached to the VALUES part of INSERT ... VALUES. - Fix constant-folding of COALESCE() expressions. The planner would sometimes attempt to evaluate sub-expressions that in fact could never be reached, possibly leading to unexpected errors. - Fix postmaster crash when connection acceptance (accept() or one of the calls made immediately after it) fails, and the postmaster was compiled with GSSAPI support. - Fix missed unlink of temporary files when log_temp_files is active. If an error occurred while attempting to emit the log message, the unlink was not done, resulting in accumulation of temp files. - Add print functionality for InhRelation nodes. This avoids a failure when debug_print_parse is enabled and certain types of query are executed. - Fix incorrect calculation of distance from a point to a horizontal line segment. This bug affected several different geometric distance-measurement operators. - Fix incorrect calculation of transaction status in ecpg. - Fix PL/pgSQL's handling of "simple" expressions to not fail in recursion or error-recovery cases. - Fix PL/Python's handling of set-returning functions. Attempts to call SPI functions within the iterator generating a set result would fail. - Fix bug in "contrib/cube"'s GiST picksplit algorithm. This could result in considerable inefficiency, though not actually incorrect answers, in a GiST index on a cube column. If you have such an index, consider "REINDEX"ing it after installing this update. - Don't emit "identifier will be truncated" notices in "contrib/dblink" except when creating new connections. - Fix potential coredump on missing public key in "contrib/pgcrypto". - Fix memory leak in "contrib/xml2"'s XPath query functions. Checksums-Sha1: 35355d2c29f952547a9a90f9c54a75722533906a 188340 libpq-dev_8.4.6-0ubuntu9.10_armel.deb e2591346f503601a743c48357ad2cd047af95a5a 2078500 postgresql-8.4_8.4.6-0ubuntu9.10_armel_translations.tar.gz 24fd7b6db02d4db4641e35d294b5ee183987f987 80422 libpq5_8.4.6-0ubuntu9.10_armel.deb 656a27d18feafad45315520f588706427395a90f 31302 libecpg6_8.4.6-0ubuntu9.10_armel.deb 228435c75e8ba0075fc7981cf7699f20afcb4f3d 224596 libecpg-dev_8.4.6-0ubuntu9.10_armel.deb 85dd17ea058bec4c67bd4d5cb10c612d0876e248 9946 libecpg-compat3_8.4.6-0ubuntu9.10_armel.deb a75dbfac2844752e312ace463d2e710db579c176 49786 libpgtypes3_8.4.6-0ubuntu9.10_armel.deb 90c95f8134f869bcf6f9353a8b90c2b59c1fb93b 3870546 postgresql-8.4_8.4.6-0ubuntu9.10_armel.deb 0b744d4bcd8426c1101da5d91a339eec8917a8e5 765266 postgresql-client-8.4_8.4.6-0ubuntu9.10_armel.deb 133390431c4c0e1241890e892e341190699bcb16 634526 postgresql-server-dev-8.4_8.4.6-0ubuntu9.10_armel.deb 24ef403e6bf34bb5ccfcc9e05e1f270b87db922a 363928 postgresql-contrib-8.4_8.4.6-0ubuntu9.10_armel.deb 37eb2d00a61ebc8d2f220acbafc48c5c58fb2c7e 46186 postgresql-plperl-8.4_8.4.6-0ubuntu9.10_armel.deb 8d70085539d88c073789a81eec1c09f14c46262f 40028 postgresql-plpython-8.4_8.4.6-0ubuntu9.10_armel.deb 719a1c32c2e82ce85d212f0d8b1aa6e9801ae585 38090 postgresql-pltcl-8.4_8.4.6-0ubuntu9.10_armel.deb Checksums-Sha256: 576f9279544d2dc954b9a35eaff942c0aa85d6e737445bdbbf169e6ca82ab87c 188340 libpq-dev_8.4.6-0ubuntu9.10_armel.deb 2d77fdf082dc4db3a81fff6ccae392f3983c1aa67f63c71fa9aa972005bea644 2078500 postgresql-8.4_8.4.6-0ubuntu9.10_armel_translations.tar.gz b1d7a1e4d899d58f0d5602f925fcb4c2067e6ec19c5fca0eb7e665579c1e22ce 80422 libpq5_8.4.6-0ubuntu9.10_armel.deb 78981bcc8eb5425907d12b806faa4833c4340ca5936f0114d8008f97d4479562 31302 libecpg6_8.4.6-0ubuntu9.10_armel.deb 6f015b8504c18ab349fdade6a732702eef930b0f7f342637c91f84ebd6f4edc7 224596 libecpg-dev_8.4.6-0ubuntu9.10_armel.deb 252442f1d43554caf009ca054f5ba6ed9b37ca838571413178fd16447ff740f1 9946 libecpg-compat3_8.4.6-0ubuntu9.10_armel.deb fb23e86664a5e9176e0b5d2fa930d51571671597ff4b0beea3d4b4965aed2472 49786 libpgtypes3_8.4.6-0ubuntu9.10_armel.deb 9bce3d8123ae24951addcecadea8cbe7e9f9de80629ff3b4db09d9121a65bc9b 3870546 postgresql-8.4_8.4.6-0ubuntu9.10_armel.deb 2f3d55a5f277499d22fd413c87693cfa7c92f3e0978dc75f4fe15d2bc06e3626 765266 postgresql-client-8.4_8.4.6-0ubuntu9.10_armel.deb 48aa7510b305060d8d3bc2f697925217d9eac5c00296fcce2b200a6c3e697211 634526 postgresql-server-dev-8.4_8.4.6-0ubuntu9.10_armel.deb 62b7cc03b1482063ed7655d21abd83df64ac3355fbd812ba74196a2cd723f9dc 363928 postgresql-contrib-8.4_8.4.6-0ubuntu9.10_armel.deb 0c0aae67391848acae72fdd054a57edf51b6335a2fe99c0f2c5357f8406b102c 46186 postgresql-plperl-8.4_8.4.6-0ubuntu9.10_armel.deb 9403faa9ddd7e71e3b3e1a3e8e8452fb250bffa75ba8682e9be5766127e3b653 40028 postgresql-plpython-8.4_8.4.6-0ubuntu9.10_armel.deb 9f3cd1ae8f3c75ae2345b905dd01cfa284c513351c7bd6ee47fb761eca3d8238 38090 postgresql-pltcl-8.4_8.4.6-0ubuntu9.10_armel.deb Files: 2458248ee0925a55f46b21231dc02fb4 188340 libdevel optional libpq-dev_8.4.6-0ubuntu9.10_armel.deb 81eb650d908513eac855af4f88882cc4 2078500 raw-translations - postgresql-8.4_8.4.6-0ubuntu9.10_armel_translations.tar.gz 4d2887720c10f5a0ede47348c11caa21 80422 libs optional libpq5_8.4.6-0ubuntu9.10_armel.deb c33cc9b829188cb15fbf627994fa8d50 31302 libs optional libecpg6_8.4.6-0ubuntu9.10_armel.deb 691578c161d4fe30dd212db548f1f843 224596 libdevel optional libecpg-dev_8.4.6-0ubuntu9.10_armel.deb 3098b143ea03810cb9db95fefe21b8bc 9946 libs optional libecpg-compat3_8.4.6-0ubuntu9.10_armel.deb 0c9f36330d85b964cae0c26d52d1041a 49786 libs optional libpgtypes3_8.4.6-0ubuntu9.10_armel.deb 5a64dce1fa2087111855e320b54b2be4 3870546 database optional postgresql-8.4_8.4.6-0ubuntu9.10_armel.deb 4c46ede8920c07e7dc7a4e4b3484671c 765266 database optional postgresql-client-8.4_8.4.6-0ubuntu9.10_armel.deb 0d49ca23e32b11ab74999acbe7a364c4 634526 libdevel optional postgresql-server-dev-8.4_8.4.6-0ubuntu9.10_armel.deb d02b296400f33f51446d7496644eb4f9 363928 database optional postgresql-contrib-8.4_8.4.6-0ubuntu9.10_armel.deb 79cebe5a3200c8afb9031db51c360537 46186 database optional postgresql-plperl-8.4_8.4.6-0ubuntu9.10_armel.deb 477d0d1d04c6a3abd6a126283de2bd40 40028 database optional postgresql-plpython-8.4_8.4.6-0ubuntu9.10_armel.deb 1a1e876a4babd0acb9dbe490e1465a6d 38090 database optional postgresql-pltcl-8.4_8.4.6-0ubuntu9.10_armel.deb Launchpad-Bugs-Fixed: 693157