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: powerpc powerpc_translations Version: 8.4.6-0ubuntu10.04 Distribution: lucid-proposed Urgency: low Maintainer: Ubuntu/powerpc 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: d534a2ccf92ad9f8ca1e953eaa36e1a0e701e82c 199750 libpq-dev_8.4.6-0ubuntu10.04_powerpc.deb 5e4f6e3ba34348387304d919b09215e07c711317 2073606 postgresql-8.4_8.4.6-0ubuntu10.04_powerpc_translations.tar.gz f276f63d6fadde77a758ee25e091782c42fdca54 88356 libpq5_8.4.6-0ubuntu10.04_powerpc.deb cb10f0753968fd79587805e80fbfd6cb7162e899 34572 libecpg6_8.4.6-0ubuntu10.04_powerpc.deb 193017d8973ddc7baba1e1769c8ba6e7ed42a1b6 241346 libecpg-dev_8.4.6-0ubuntu10.04_powerpc.deb cc824f8ac05360d6c0ae9f6b3e9b46b9ddf86fdb 10996 libecpg-compat3_8.4.6-0ubuntu10.04_powerpc.deb a57f01b0c9fe8d1433857d748f082d1319eabf4e 53608 libpgtypes3_8.4.6-0ubuntu10.04_powerpc.deb 0004c2f441ac9347103dcbc0d6c57414b19283d1 4361680 postgresql-8.4_8.4.6-0ubuntu10.04_powerpc.deb 18b31ccc3136f6a9cd21ed80e9c783f1c6c6b30b 828540 postgresql-client-8.4_8.4.6-0ubuntu10.04_powerpc.deb 33d663a1eeff042adf89c8f8681d829b771b3deb 634684 postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_powerpc.deb 3473be33fa3bd1dd43e800a081d08689bf244646 397364 postgresql-contrib-8.4_8.4.6-0ubuntu10.04_powerpc.deb 2e4d5f8664d48ea8ed51ac650d9c75d17c17b2ab 47890 postgresql-plperl-8.4_8.4.6-0ubuntu10.04_powerpc.deb 364f18e52a1eb623fb2a9b5f717abdf6f57f545e 40864 postgresql-plpython-8.4_8.4.6-0ubuntu10.04_powerpc.deb 1704fceb23ebc0a308ead7342d6b59821106b462 38868 postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_powerpc.deb Checksums-Sha256: 1da72d6cfa6703878093a048b3ebfab37cea469de2b66ea1ff8c112883fd56fe 199750 libpq-dev_8.4.6-0ubuntu10.04_powerpc.deb 531f36407eeeb77a749494ec1daa3883fea08b25c5987510cbc3b74a0c18d18b 2073606 postgresql-8.4_8.4.6-0ubuntu10.04_powerpc_translations.tar.gz a62ba9f749e7f8a61ba720956c7f1548fac4451c6fe688fac7601e511a5a8569 88356 libpq5_8.4.6-0ubuntu10.04_powerpc.deb 8ba16c7e8245b3197c7a5f01174ec86b89df8b9a9a28e12ff7bc7b7e4a090b61 34572 libecpg6_8.4.6-0ubuntu10.04_powerpc.deb f3f606f59488ed3171d99288ccac85478c688dbe20d254b2b6dd489b9a03cdcf 241346 libecpg-dev_8.4.6-0ubuntu10.04_powerpc.deb 269b24ee42e502e22affd15e77e013a549fb9b1517132e55f5b22906d9fa25d3 10996 libecpg-compat3_8.4.6-0ubuntu10.04_powerpc.deb 09fca6be82fc2a69c1dc3173b842b3eb82fbc9d65328135fed92e1ac6cb81f35 53608 libpgtypes3_8.4.6-0ubuntu10.04_powerpc.deb e453b114c4bbc84532f9fc6c0d46187798826aba09c9416ec91cc824db2afea0 4361680 postgresql-8.4_8.4.6-0ubuntu10.04_powerpc.deb 6096a24befd2854e01ac8568a5e078f50157bfc5be39d1e7ddbf0ef3aef580ab 828540 postgresql-client-8.4_8.4.6-0ubuntu10.04_powerpc.deb c5099fcab144c166a2fd734c0854c48d7b3cb54f7daf87c88c6696398bce909c 634684 postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_powerpc.deb 80a9719467bd81cd8fcba5e5d607106b04d115130481dfd3b05921d3b1b7ba8f 397364 postgresql-contrib-8.4_8.4.6-0ubuntu10.04_powerpc.deb 2745a7ff41eea3dffa977766ce9ceddc4a9493a139816e26cb080cc15de9de4c 47890 postgresql-plperl-8.4_8.4.6-0ubuntu10.04_powerpc.deb a6a5ec3b248d9649d669c06ed49c2d1d86dd3b16a887018f32e5af5590d7c1be 40864 postgresql-plpython-8.4_8.4.6-0ubuntu10.04_powerpc.deb 260a15dc9dba7afd0ec5eac4f7c4236134e49d0e56a5cd207eb81de9d912d143 38868 postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_powerpc.deb Files: d5f59d634f027bcadf5418fa93324a5f 199750 libdevel optional libpq-dev_8.4.6-0ubuntu10.04_powerpc.deb c23733ff71b9e29e2fa6c2413c882793 2073606 raw-translations - postgresql-8.4_8.4.6-0ubuntu10.04_powerpc_translations.tar.gz 45cdc380e3ca7bc76ec6fb97b1626a5e 88356 libs optional libpq5_8.4.6-0ubuntu10.04_powerpc.deb f3888fd04f6435802c214b28dcba71a7 34572 libs optional libecpg6_8.4.6-0ubuntu10.04_powerpc.deb 928e40df37b72656718fe93174a3e245 241346 libdevel optional libecpg-dev_8.4.6-0ubuntu10.04_powerpc.deb 19bcfdc347c49330ba6a224aace2580b 10996 libs optional libecpg-compat3_8.4.6-0ubuntu10.04_powerpc.deb 40602f2513c15b58db190e1f67c76b7d 53608 libs optional libpgtypes3_8.4.6-0ubuntu10.04_powerpc.deb b3e1817c44bdb0cbd310607a47fa7a22 4361680 database optional postgresql-8.4_8.4.6-0ubuntu10.04_powerpc.deb 2c21bc294ae9e9adef4ae586691db23f 828540 database optional postgresql-client-8.4_8.4.6-0ubuntu10.04_powerpc.deb a46b49b5b58fc22c5f567e9ef44f2117 634684 libdevel optional postgresql-server-dev-8.4_8.4.6-0ubuntu10.04_powerpc.deb c69eedb576d3405d146c7222bcd442d7 397364 database optional postgresql-contrib-8.4_8.4.6-0ubuntu10.04_powerpc.deb 5709457f1de0576020c981adea07f9cf 47890 database optional postgresql-plperl-8.4_8.4.6-0ubuntu10.04_powerpc.deb 1ef1f3fe57acd7cfb6b31cced7b37673 40864 database optional postgresql-plpython-8.4_8.4.6-0ubuntu10.04_powerpc.deb cf466979c973e4b075e075fe27c30d8e 38868 database optional postgresql-pltcl-8.4_8.4.6-0ubuntu10.04_powerpc.deb