Format: 1.8 Date: Tue, 21 Dec 2010 21:06:25 +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: all i386_translations i386 Version: 8.4.6-0ubuntu10.10 Distribution: maverick-proposed Urgency: low Maintainer: Ubuntu/i386 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.10) maverick-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: 6491368af8c41190931c633aeab4fc5c01fa35c0 1919326 postgresql-doc-8.4_8.4.6-0ubuntu10.10_all.deb 6d005ad2025f0656567fe08b203e442d2e9f7632 1957897 postgresql-8.4_8.4.6-0ubuntu10.10_i386_translations.tar.gz 02b4c8df287c728ed2d6553114c0ed4bfb75f3d1 19736 postgresql_8.4.6-0ubuntu10.10_all.deb c0c406a5fae2214e49f077b62a888001d550bc47 19706 postgresql-client_8.4.6-0ubuntu10.10_all.deb 2818ef4968b7de43c327ecc9eb141e05c4857fad 3416 postgresql-doc_8.4.6-0ubuntu10.10_all.deb 20cdbff0941b520bd07e913121e90a8ae1a17658 19602 postgresql-contrib_8.4.6-0ubuntu10.10_all.deb ffc5e64c526cfb39670e5d34e0d57e7be6a7a83b 192472 libpq-dev_8.4.6-0ubuntu10.10_i386.deb 7cbfdc48f4a578b97b5cac9621cfdc1cb66561ba 84776 libpq5_8.4.6-0ubuntu10.10_i386.deb b340337604d933067922451249b6e29b05ff61f7 32044 libecpg6_8.4.6-0ubuntu10.10_i386.deb b342d13b7b22dab0d09320f26eea1af57103aa15 225450 libecpg-dev_8.4.6-0ubuntu10.10_i386.deb a37994ecb86413134651436c8276f9d33c66c31c 10284 libecpg-compat3_8.4.6-0ubuntu10.10_i386.deb 0439e913a579c5a337ba84f2921f72380fa66f6f 49830 libpgtypes3_8.4.6-0ubuntu10.10_i386.deb 066ad52f444eb3be0bc63357df8f130dfca84f39 3876328 postgresql-8.4_8.4.6-0ubuntu10.10_i386.deb 6a06bd97115e898f1a0a81fd608150eebc53e8cd 781320 postgresql-client-8.4_8.4.6-0ubuntu10.10_i386.deb 92c418844cc2976b853945f4aad0dde84bb8d732 628816 postgresql-server-dev-8.4_8.4.6-0ubuntu10.10_i386.deb d7f4ad3dd12e7ae78ae6d47cb5ee5fa8c6c1e09c 362856 postgresql-contrib-8.4_8.4.6-0ubuntu10.10_i386.deb 22d91c96d4e1e0b6b274938c05b4b3be478785a3 46742 postgresql-plperl-8.4_8.4.6-0ubuntu10.10_i386.deb ead6a66029c89b34801fed85bc4eb8d1ce595dbb 39182 postgresql-plpython-8.4_8.4.6-0ubuntu10.10_i386.deb 8bab6efca228b24f47a9ca83209b31e75727e5c5 38210 postgresql-pltcl-8.4_8.4.6-0ubuntu10.10_i386.deb Checksums-Sha256: 90b340f77f7c9ab9525d73a8e6b4de974842ee175ec8ca55f917b484b3140e75 1919326 postgresql-doc-8.4_8.4.6-0ubuntu10.10_all.deb 392ccd50e9e1cf16de7d94b0fb964b02deafa8899fd8e55dc6dab5a4699cabcf 1957897 postgresql-8.4_8.4.6-0ubuntu10.10_i386_translations.tar.gz 24c8ae13555b9c574fc54ad5d8945efab67f734e076f424ddacbb92319be25ce 19736 postgresql_8.4.6-0ubuntu10.10_all.deb 802ef3a762ca8829697e35fba05a61680d2eed7b0105e8e4885b0760ac994df0 19706 postgresql-client_8.4.6-0ubuntu10.10_all.deb 21719cda6a2790e763ca5d4242208ba2ee7745f264359341abb3b75020407c49 3416 postgresql-doc_8.4.6-0ubuntu10.10_all.deb 92e966a0338699a95bbdb9901b71cb4d0ade298005c80cbd73a7d19af9ce332a 19602 postgresql-contrib_8.4.6-0ubuntu10.10_all.deb 4d6650bfac77ab2c8a80a79c9bc8c89ce15dfd68ec2d57db335c0f8f4af64ade 192472 libpq-dev_8.4.6-0ubuntu10.10_i386.deb cdd667127caf220f18af847c6b677cb68bdbbbf23c5510f255e2218be36ca035 84776 libpq5_8.4.6-0ubuntu10.10_i386.deb 27a684edacb51316c535f4f4d1560d56be3eb01a9d297643424c298575e4a11a 32044 libecpg6_8.4.6-0ubuntu10.10_i386.deb 6b8ba8bd489e25bdd0abea64408055737acbadb9c130665104aa6f76208d1a95 225450 libecpg-dev_8.4.6-0ubuntu10.10_i386.deb caf29fdb783c97e2efa7f14d3f619206ce4e3d80c384343e9126e7c96f57db2c 10284 libecpg-compat3_8.4.6-0ubuntu10.10_i386.deb 032f6324f42fc6827affcf12f0b32cbc4ebfa153861cb51707c1e9c8203044c9 49830 libpgtypes3_8.4.6-0ubuntu10.10_i386.deb c71a834d275d5354e3627916ae826be8a9fa74e5c2929509113d0d3dd29cf8cd 3876328 postgresql-8.4_8.4.6-0ubuntu10.10_i386.deb 099b33e25a8adabb5039304eb2e2530d938d9ffa8a5b8bb3dc82500833583701 781320 postgresql-client-8.4_8.4.6-0ubuntu10.10_i386.deb 8def79ae31ae6194af3440e667dda787296b786199c7c4a69de24756f73da9d6 628816 postgresql-server-dev-8.4_8.4.6-0ubuntu10.10_i386.deb c85bbc96c6ac474b35c05d7003b9efea599c60a297072ef8c514a28b89dde659 362856 postgresql-contrib-8.4_8.4.6-0ubuntu10.10_i386.deb 75a094f6f6e41e4063faf67cb0310cdc816d7c4d2bb0ae53d7acd30fdcdbdd8a 46742 postgresql-plperl-8.4_8.4.6-0ubuntu10.10_i386.deb 5e9f7c3d2b21d36e501c1853be52a196ae84bdb7722023bb5617bef3fe897925 39182 postgresql-plpython-8.4_8.4.6-0ubuntu10.10_i386.deb bf55a555cba08560eccba3e9fb7a2e6aff4f490d6b94f54dcc51ea7f25b5614f 38210 postgresql-pltcl-8.4_8.4.6-0ubuntu10.10_i386.deb Files: f3376c617bd11a69486eec125a8f5125 1919326 doc optional postgresql-doc-8.4_8.4.6-0ubuntu10.10_all.deb 3a7bc68bd218862eeb116a89f45905a0 1957897 raw-translations - postgresql-8.4_8.4.6-0ubuntu10.10_i386_translations.tar.gz 2c32a171057bf7d188acf2e5c4f2460c 19736 database optional postgresql_8.4.6-0ubuntu10.10_all.deb bab08cad267b8ce7941e678b6286b389 19706 database optional postgresql-client_8.4.6-0ubuntu10.10_all.deb 5b67ada122f3fc8a762fa540a410c994 3416 doc optional postgresql-doc_8.4.6-0ubuntu10.10_all.deb b26656ed442aef8cd854ec32cfda91cc 19602 database optional postgresql-contrib_8.4.6-0ubuntu10.10_all.deb af7b67494c970665061a5db95359bb8f 192472 libdevel optional libpq-dev_8.4.6-0ubuntu10.10_i386.deb aba473dda1225e681ea8eddd18bcdd8c 84776 libs optional libpq5_8.4.6-0ubuntu10.10_i386.deb b51e0765a2f2c24e4d7614d8321c8a13 32044 libs optional libecpg6_8.4.6-0ubuntu10.10_i386.deb a7ba6dcfad56d4fa5f8c29cb399f5d0a 225450 libdevel optional libecpg-dev_8.4.6-0ubuntu10.10_i386.deb e5f4796184b3ed4303543d2bda542829 10284 libs optional libecpg-compat3_8.4.6-0ubuntu10.10_i386.deb 49aa5471940909b4b69c3e831963eb45 49830 libs optional libpgtypes3_8.4.6-0ubuntu10.10_i386.deb 8494dd1e49df2de3c11fa4674c26c1eb 3876328 database optional postgresql-8.4_8.4.6-0ubuntu10.10_i386.deb d91416e44645e220dbc26acdf2eb3bd4 781320 database optional postgresql-client-8.4_8.4.6-0ubuntu10.10_i386.deb 0eb0140d5266d5b5fa2e62be88ad6a13 628816 libdevel optional postgresql-server-dev-8.4_8.4.6-0ubuntu10.10_i386.deb 6171e2a8878a0ca426d9f3420fc57b4a 362856 database optional postgresql-contrib-8.4_8.4.6-0ubuntu10.10_i386.deb 6178109c5e36f1ff479044a76d1e5ee3 46742 database optional postgresql-plperl-8.4_8.4.6-0ubuntu10.10_i386.deb 141b468a54514a5bb5a2fcfccc354925 39182 database optional postgresql-plpython-8.4_8.4.6-0ubuntu10.10_i386.deb dc438b437b469f278937641a9e6056e0 38210 database optional postgresql-pltcl-8.4_8.4.6-0ubuntu10.10_i386.deb