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: armel armel_translations Version: 8.4.6-0ubuntu10.04 Distribution: lucid-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 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: 2a70af9deb7b1afa84f45c75d571bad97b1080cb 182612 libpq-dev_8.4.6-0ubuntu10.04_armel.deb ea9ae65d4c437f7f92717ab5dd778bafb4b121bc 2078450 postgresql-8.4_8.4.6-0ubuntu10.04_armel_translations.tar.gz 34fff8419e2e79a9193476373d5b878b79654aba 77874 libpq5_8.4.6-0ubuntu10.04_armel.deb b7760bc28010d56ad3fcec01b3118125e90aaed5 29780 libecpg6_8.4.6-0ubuntu10.04_armel.deb 3dd4fa0af7fac3be32309582776aa5997207dfd8 222408 libecpg-dev_8.4.6-0ubuntu10.04_armel.deb 604b7614ec4edfd99c72b134dd4e6e8ce10a2a90 9762 libecpg-compat3_8.4.6-0ubuntu10.04_armel.deb b2acee6079912adeb56778197219c54896fda01c 48706 libpgtypes3_8.4.6-0ubuntu10.04_armel.deb 1c95b9b9fb4d01456274c51d839e314db8fde4b3 3770788 postgresql-8.4_8.4.6-0ubuntu10.04_armel.deb 296007d44c73cf7cbf1017689cec1a936a0132e5 750664 postgresql-client-8.4_8.4.6-0ubuntu10.04_armel.deb a11c06ac9e78d6ddb5a2fd292b501329a9e1f05f 636324 postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_armel.deb 8b8a593eef64c6d9b389bdfbb359620174a7e2d1 354224 postgresql-contrib-8.4_8.4.6-0ubuntu10.04_armel.deb cacff07ddf05e4fe1c1b275ffe90152192cf555e 45940 postgresql-plperl-8.4_8.4.6-0ubuntu10.04_armel.deb 65bc333e8dd843a8c71ca6e518a4d3cf943aeb32 39226 postgresql-plpython-8.4_8.4.6-0ubuntu10.04_armel.deb 48d67fc440a4b39058e9359e0faa6d0a3e5dc202 37918 postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_armel.deb Checksums-Sha256: baee4afd7ff27c46d9a50fc4518c01009b99852047304e12b50159126c50f4a6 182612 libpq-dev_8.4.6-0ubuntu10.04_armel.deb 0b8a78531d508f8fe781bac7522cb33de47348e15e10fef242bc78439975a253 2078450 postgresql-8.4_8.4.6-0ubuntu10.04_armel_translations.tar.gz f60f6559472af5d85a56ace0256cd5d16b3d739857ca812417b4156a53a0f63d 77874 libpq5_8.4.6-0ubuntu10.04_armel.deb cec7ca4908f819003330a8760ad2cb13d6deecdb8a594bc54860467a2938b35e 29780 libecpg6_8.4.6-0ubuntu10.04_armel.deb b6ee8191144b4d8f21ad0a85858968559dcf74eda7d76c816593109150da2b22 222408 libecpg-dev_8.4.6-0ubuntu10.04_armel.deb dc4bd063aaaa53ef27f28247fb3dca7dc122185808a0c61fe8e889b30b0969a9 9762 libecpg-compat3_8.4.6-0ubuntu10.04_armel.deb 952bcce7653162c7fa93921813d68e6615e9faa95308d12ca905327268f2cfb6 48706 libpgtypes3_8.4.6-0ubuntu10.04_armel.deb ae9e1c3a77be79c7410167960eba931d61015986fd65e3f79c2776f11d7016f2 3770788 postgresql-8.4_8.4.6-0ubuntu10.04_armel.deb 088c08744219624d04897bf69e56a6d3426cd1bb773006b2ca9b53360f4d05cd 750664 postgresql-client-8.4_8.4.6-0ubuntu10.04_armel.deb ddc7bcc795efa99a7f123905ccb8ff87a6814af880354f3d6f825b535ee4e2f1 636324 postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_armel.deb 23ff8d07d48037c3c9d20ca6d21539b69ecd0f99f9be723a890559b34aaa70fd 354224 postgresql-contrib-8.4_8.4.6-0ubuntu10.04_armel.deb 7ec16b82b05965a66d1b2e50317494ca2145b10206f9d0df9c813e56321e1160 45940 postgresql-plperl-8.4_8.4.6-0ubuntu10.04_armel.deb 0049e013532d20b7e352ef06e3a0513a4a6c9b7b2ba7c245587344d9a9bf6c53 39226 postgresql-plpython-8.4_8.4.6-0ubuntu10.04_armel.deb 3debbb49f839a5a15836c3cb269d2c50e5dd406a5a6db829655887a974e759b6 37918 postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_armel.deb Files: da729fa802511e5617847e818598d31c 182612 libdevel optional libpq-dev_8.4.6-0ubuntu10.04_armel.deb 39876e179de60c2cc36a17734d87f7af 2078450 raw-translations - postgresql-8.4_8.4.6-0ubuntu10.04_armel_translations.tar.gz 2858d00ddcf7580d54e127ba2ada8174 77874 libs optional libpq5_8.4.6-0ubuntu10.04_armel.deb 449b39b16114b7327cee590a0b99781b 29780 libs optional libecpg6_8.4.6-0ubuntu10.04_armel.deb 77ab708aea16cb4435bb828ea5d02c17 222408 libdevel optional libecpg-dev_8.4.6-0ubuntu10.04_armel.deb 5b0d1cec4307fc3ae6c6db5df9701928 9762 libs optional libecpg-compat3_8.4.6-0ubuntu10.04_armel.deb ee961038a4b06850b9b83b4be1eec76e 48706 libs optional libpgtypes3_8.4.6-0ubuntu10.04_armel.deb b2c1d11fd3749e974772fcd30170e71f 3770788 database optional postgresql-8.4_8.4.6-0ubuntu10.04_armel.deb 4e8f030d7a8000f78e7d2d7711b780dc 750664 database optional postgresql-client-8.4_8.4.6-0ubuntu10.04_armel.deb 48f4f54c2c2f6b440d9589222aa22356 636324 libdevel optional postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_armel.deb 29e1363716897945eb05dd15eb19375b 354224 database optional postgresql-contrib-8.4_8.4.6-0ubuntu10.04_armel.deb 9478c303ce5e52766ee6cddefe1c7637 45940 database optional postgresql-plperl-8.4_8.4.6-0ubuntu10.04_armel.deb b794dec19173da3053e91d28f375cfdb 39226 database optional postgresql-plpython-8.4_8.4.6-0ubuntu10.04_armel.deb a1a21c4fa832deb59d9edf2ce3e81d3f 37918 database optional postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_armel.deb