Format: 1.8 Date: Tue, 21 Dec 2010 21:13:09 +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: amd64 amd64_translations Version: 8.4.6-0ubuntu10.04 Distribution: lucid-proposed Urgency: low Maintainer: Ubuntu/amd64 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 Launchpad-Bugs-Fixed: 693157 Changes: postgresql-8.4 (8.4.6-0ubuntu10.04) lucid-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: c39d9725584e50dd8b0f70caaa337ceeecd0a035 201610 libpq-dev_8.4.6-0ubuntu10.04_amd64.deb 0de535a59475658060616a52b824f2c355ab3081 2073244 postgresql-8.4_8.4.6-0ubuntu10.04_amd64_translations.tar.gz 8501fa049bba0f73d5ab483cbc5aa56334d6bf36 90652 libpq5_8.4.6-0ubuntu10.04_amd64.deb 32b776d0efb2d7067fb2e0f0f55ebcd0c057e757 33460 libecpg6_8.4.6-0ubuntu10.04_amd64.deb 08221e0fcd56bab2e5edcffaf37e39e654b97df9 241008 libecpg-dev_8.4.6-0ubuntu10.04_amd64.deb 9fea3a6937e984fd1ec774b637c382d7e73367d4 11526 libecpg-compat3_8.4.6-0ubuntu10.04_amd64.deb c245502799877745d9333d295808674ae160aacf 51064 libpgtypes3_8.4.6-0ubuntu10.04_amd64.deb 884770803d838561c4aeef69a8671a2722003a98 4050174 postgresql-8.4_8.4.6-0ubuntu10.04_amd64.deb 2ff9dfdd928f06f9bbff7097a29d57a8fd7a94d0 826716 postgresql-client-8.4_8.4.6-0ubuntu10.04_amd64.deb 8d655cd4602636b259eb58f17dc543283be0efcf 633332 postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_amd64.deb aa1191dc7d01ccff159b379892fcabfdde11096f 414442 postgresql-contrib-8.4_8.4.6-0ubuntu10.04_amd64.deb 1884ddf0162e4d55ac822c5f949cf625ef540954 48706 postgresql-plperl-8.4_8.4.6-0ubuntu10.04_amd64.deb 26827d775f888f62284f8f44d5e234c94214281b 41692 postgresql-plpython-8.4_8.4.6-0ubuntu10.04_amd64.deb 155d9e54f63a195beccc4359030339784d62e1ff 39186 postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_amd64.deb Checksums-Sha256: ad2980aacb24f70f451650d5b775d9c44c675778ec784757f18acba823700a0e 201610 libpq-dev_8.4.6-0ubuntu10.04_amd64.deb 1949e78f6baf900c6b28adce9a735ad392352419a77d5ff866d822786da2c7de 2073244 postgresql-8.4_8.4.6-0ubuntu10.04_amd64_translations.tar.gz 418ebb30facfae3946dc47598cb0c77bf1ffe0d3546dcd08733ef4bdcdde752e 90652 libpq5_8.4.6-0ubuntu10.04_amd64.deb 6f104f02be35611f1977f2df9d04c25e9f19dcdd5d82e6f31a3b2e4d5542916b 33460 libecpg6_8.4.6-0ubuntu10.04_amd64.deb 32f40f6470b1319d28a0aafd275840b323e5547e791d85d5a11e207f39d0c5a7 241008 libecpg-dev_8.4.6-0ubuntu10.04_amd64.deb 59cbaa1bf46972d2622a45a3fa675685d5fef96289d7cd6d16271df8485563c9 11526 libecpg-compat3_8.4.6-0ubuntu10.04_amd64.deb d58755efe7b16f582c7b942c0fbc37e7e7c0b1123e7a4cb3f31cbfb6796b9691 51064 libpgtypes3_8.4.6-0ubuntu10.04_amd64.deb 45bf52d192faabb0879171b6458ba5334a53e7ad85866b2cb775244fb11609ed 4050174 postgresql-8.4_8.4.6-0ubuntu10.04_amd64.deb d2829d91e99806cc2b751f17418b0f0ce333ddd59b328cbae640187332cdce87 826716 postgresql-client-8.4_8.4.6-0ubuntu10.04_amd64.deb 7377704aab440a02480cbbe2784c427a5573604403dee6b9f68dcada83b0917d 633332 postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_amd64.deb 093d63417c823ee3fae6a60eeb79ab6d59af9fb73d80436bd1abee97ee61c198 414442 postgresql-contrib-8.4_8.4.6-0ubuntu10.04_amd64.deb 5d0247a6a36cde80d071e670984cc3d25ebaccbf1d42298559d24f314b1afa91 48706 postgresql-plperl-8.4_8.4.6-0ubuntu10.04_amd64.deb cd8da5da73f367a8b199f0c4d1ee9200191300ba5b9c1f23a636102e7f216b00 41692 postgresql-plpython-8.4_8.4.6-0ubuntu10.04_amd64.deb e3fd8cdfab1532adbbdabe1027f4ee0ec3e8cd5821874f66ca7e5b8b2c882804 39186 postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_amd64.deb Files: c860fb9c7bed433a7466bd4408808e86 201610 libdevel optional libpq-dev_8.4.6-0ubuntu10.04_amd64.deb 2fa9a93adf49b3e29179d07c9ffce3b0 2073244 raw-translations - postgresql-8.4_8.4.6-0ubuntu10.04_amd64_translations.tar.gz 20eed03a17c1c62ac5c10dd83d6320c7 90652 libs optional libpq5_8.4.6-0ubuntu10.04_amd64.deb 9a90b5e4f203da4c18b950c33baeaa1e 33460 libs optional libecpg6_8.4.6-0ubuntu10.04_amd64.deb dc0f334109b34f169a0922fd90b46004 241008 libdevel optional libecpg-dev_8.4.6-0ubuntu10.04_amd64.deb 2e4c4b381fa62963444f52d575aae6cd 11526 libs optional libecpg-compat3_8.4.6-0ubuntu10.04_amd64.deb e9375e44266bf12f633dc27388735a38 51064 libs optional libpgtypes3_8.4.6-0ubuntu10.04_amd64.deb fb81bd01357113481f99f574bad7052a 4050174 database optional postgresql-8.4_8.4.6-0ubuntu10.04_amd64.deb 9215f9639d92e4e99a097a7d906dddb1 826716 database optional postgresql-client-8.4_8.4.6-0ubuntu10.04_amd64.deb 8fd10e082a32418d62d6ff07e9d5ad8c 633332 libdevel optional postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_amd64.deb 1ac8ef1a78c34d5c6f34f5bde618510e 414442 database optional postgresql-contrib-8.4_8.4.6-0ubuntu10.04_amd64.deb bbedd8c1a8c65fcbee148faecda251e4 48706 database optional postgresql-plperl-8.4_8.4.6-0ubuntu10.04_amd64.deb b47775a231e29f9d6e72d95e6874c255 41692 database optional postgresql-plpython-8.4_8.4.6-0ubuntu10.04_amd64.deb 18ec75910ba083522504b31689797af2 39186 database optional postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_amd64.deb