Format: 1.7 Date: Tue, 21 Dec 2010 21:36:17 +0100 Source: postgresql-8.3 Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-8.3 postgresql-client-8.3 postgresql-server-dev-8.3 postgresql-doc-8.3 postgresql-contrib-8.3 postgresql-plperl-8.3 postgresql-plpython-8.3 postgresql-pltcl-8.3 postgresql postgresql-client postgresql-doc postgresql-contrib Architecture: hppa_translations hppa Version: 8.3.13-0ubuntu8.04 Distribution: hardy-proposed Urgency: low Maintainer: Ubuntu/hppa 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.3 libpq-dev - header files for libpq5 (PostgreSQL library) libpq5 - PostgreSQL C client library postgresql - object-relational SQL database (latest version) postgresql-8.3 - object-relational SQL database, version 8.3 server postgresql-client - front-end programs for PostgreSQL (latest version) postgresql-client-8.3 - front-end programs for PostgreSQL 8.3 postgresql-contrib - additional facilities for PostgreSQL (latest version) postgresql-contrib-8.3 - additional facilities for PostgreSQL postgresql-doc - documentation for the PostgreSQL database management system postgresql-doc-8.3 - documentation for the PostgreSQL database management system postgresql-plperl-8.3 - PL/Perl procedural language for PostgreSQL 8.3 postgresql-plpython-8.3 - PL/Python procedural language for PostgreSQL 8.3 postgresql-pltcl-8.3 - PL/Tcl procedural language for PostgreSQL 8.3 postgresql-server-dev-8.3 - development files for PostgreSQL 8.3 server-side programming Launchpad-Bugs-Fixed: 693157 Changes: postgresql-8.3 (8.3.13-0ubuntu8.04) hardy-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. - 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 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. Files: 5aa7db05703fc939b26f6133d3116ead 2648994 raw-translations - postgresql-8.3_8.3.13-0ubuntu8.04_hppa_translations.tar.gz df3f5065e6c885b1358a5d0f6da78078 195688 libdevel optional libpq-dev_8.3.13-0ubuntu8.04_hppa.deb cb9274767007f161504c33828d770cd4 345174 libs optional libpq5_8.3.13-0ubuntu8.04_hppa.deb 77ec63dbe950d757e458f062119b5a9d 36138 libs optional libecpg6_8.3.13-0ubuntu8.04_hppa.deb 8a619dd8cd8747d81a6c79aef610d58d 229506 libdevel optional libecpg-dev_8.3.13-0ubuntu8.04_hppa.deb 7a8d36d69acf4fb28df5a21ade0aaf84 12076 libs optional libecpg-compat3_8.3.13-0ubuntu8.04_hppa.deb 82407705fa4c3d81d45f331bb2688723 310986 libs optional libpgtypes3_8.3.13-0ubuntu8.04_hppa.deb 1f60f5b8c1b215f1f3e0e0bd28c8fc04 4205504 misc optional postgresql-8.3_8.3.13-0ubuntu8.04_hppa.deb 8b5d3bbe80aeb3ee88a56ab58bc0ef63 768454 misc optional postgresql-client-8.3_8.3.13-0ubuntu8.04_hppa.deb 8cab1672a2cbd40e8bcfcb2dbd0b0334 847728 libdevel optional postgresql-server-dev-8.3_8.3.13-0ubuntu8.04_hppa.deb 3a1166ca357dfa9ccd17a48b4c918d25 383088 misc optional postgresql-contrib-8.3_8.3.13-0ubuntu8.04_hppa.deb 7107ae88a51b348fa6418478b3a348a7 310306 misc optional postgresql-plperl-8.3_8.3.13-0ubuntu8.04_hppa.deb b8bc1e11f01fad62ac1faad1522a0839 300312 misc optional postgresql-plpython-8.3_8.3.13-0ubuntu8.04_hppa.deb c40173619f9167e445f5178f9d0011a7 297960 misc optional postgresql-pltcl-8.3_8.3.13-0ubuntu8.04_hppa.deb Original-Maintainer: Martin Pitt