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: powerpc_translations powerpc Version: 8.3.13-0ubuntu8.04 Distribution: hardy-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.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: a5512f3fea7f666948e4d982863489e0 2648978 raw-translations - postgresql-8.3_8.3.13-0ubuntu8.04_powerpc_translations.tar.gz 5014f848b53e73bda1be88a50a4ea0da 190552 libdevel optional libpq-dev_8.3.13-0ubuntu8.04_powerpc.deb 12db8ad2edfd6a7d80db06271c4f1b43 341760 libs optional libpq5_8.3.13-0ubuntu8.04_powerpc.deb 163008ad3574ae2fa80ceea947daaba2 34074 libs optional libecpg6_8.3.13-0ubuntu8.04_powerpc.deb 860ea0da7f6f28950285fb05a00d8ba3 217960 libdevel optional libecpg-dev_8.3.13-0ubuntu8.04_powerpc.deb c768ffd93e978397a52825c5eacae485 11258 libs optional libecpg-compat3_8.3.13-0ubuntu8.04_powerpc.deb 94f7f878c48ae484a804c3ee85ebafbd 308986 libs optional libpgtypes3_8.3.13-0ubuntu8.04_powerpc.deb 42b4ed01901fbaf998607f48f728e198 4104632 misc optional postgresql-8.3_8.3.13-0ubuntu8.04_powerpc.deb 6a52dc3804a0cc93696255a9e60e7e57 767004 misc optional postgresql-client-8.3_8.3.13-0ubuntu8.04_powerpc.deb e67d08641d4276cbafb89201ca3a56dc 846626 libdevel optional postgresql-server-dev-8.3_8.3.13-0ubuntu8.04_powerpc.deb 8fb05efd9a2cdab5c7b42a63c45ea26b 416056 misc optional postgresql-contrib-8.3_8.3.13-0ubuntu8.04_powerpc.deb b819e0f58eb14bc443d6112f9e61e692 309824 misc optional postgresql-plperl-8.3_8.3.13-0ubuntu8.04_powerpc.deb 5017ea006d9610148beab6422e483091 300392 misc optional postgresql-plpython-8.3_8.3.13-0ubuntu8.04_powerpc.deb fd013ca84fca66283e59719bbd294268 298940 misc optional postgresql-pltcl-8.3_8.3.13-0ubuntu8.04_powerpc.deb Original-Maintainer: Martin Pitt