Format: 1.8 Date: Wed, 07 Apr 2010 18:37:40 +0200 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: lpia lpia_translations Version: 8.4.3-0ubuntu9.10 Distribution: karmic-proposed Urgency: low Maintainer: Ubuntu/lpia 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 Changes: postgresql-8.4 (8.4.3-0ubuntu9.10) karmic-proposed; urgency=low . * New upstream bug fix release: (LP: #557408) - Add new configuration parameter ssl_renegotiation_limit to control how often we do session key renegotiation for an SSL connection. This can be set to zero to disable renegotiation completely, which may be required if a broken SSL library is used. In particular, some vendors are shipping stopgap patches for CVE-2009-3555 that cause renegotiation attempts to fail. - Fix possible deadlock during backend startup. - Fix possible crashes due to not handling errors during relcache reload cleanly. - Fix possible crash due to use of dangling pointer to a cached plan. - Fix possible crash due to overenthusiastic invalidation of cached plan for "ROLLBACK". - Fix possible crashes when trying to recover from a failure in subtransaction start. - Fix server memory leak associated with use of savepoints and a client encoding different from server's encoding. - Fix incorrect WAL data emitted during end-of-recovery cleanup of a GIST index page split. - Fix bug in WAL redo cleanup method for GIN indexes. - Fix incorrect comparison of scan key in GIN index search. - Make substring() for bit types treat any negative length as meaning "all the rest of the string". The previous coding treated only -1 that way, and would produce an invalid result value for other negative values, possibly leading to a crash (CVE-2010-0442). - Fix integer-to-bit-string conversions to handle the first fractional byte correctly when the output bit width is wider than the given integer by something other than a multiple of 8 bits. - Fix some cases of pathologically slow regular expression matching. - Fix bug occurring when trying to inline a SQL function that returns a set of a composite type that contains dropped columns. - Fix bug with trying to update a field of an element of a composite-type array column. - Avoid failure when "EXPLAIN" has to print a FieldStore or assignment ArrayRef expression. These cases can arise now that "EXPLAIN VERBOSE" tries to print plan node target lists. - Avoid an unnecessary coercion failure in some cases where an undecorated literal string appears in a subquery within "UNION"/"INTERSECT"/"EXCEPT". This fixes a regression for some cases that worked before 8.4. - Avoid undesirable rowtype compatibility check failures in some cases where a whole-row Var has a rowtype that contains dropped columns. - Fix the STOP WAL LOCATION entry in backup history files to report the next WAL segment's name when the end location is exactly at a segment boundary. - Always pass the catalog ID to an option validator function specified in "CREATE FOREIGN DATA WRAPPER". - Fix some more cases of temporary-file leakage. This corrects a problem introduced in the previous minor release. One case that failed is when a plpgsql function returning set is called within another function's exception handler. - Add support for doing FULL JOIN ON FALSE. This prevents a regression from pre-8.4 releases for some queries that can now be simplified to a constant-false join condition. - Improve constraint exclusion processing of boolean-variable cases, in particular make it possible to exclude a partition that has a "bool_column = false" constraint. - Prevent treating an INOUT cast as representing binary compatibility. - Include column name in the message when warning about inability to grant or revoke column-level privileges. This is more useful than before and helps to prevent confusion when a "REVOKE" generates multiple messages, which formerly appeared to be duplicates. - When reading "pg_hba.conf" and related files, do not treat @something as a file inclusion request if the @ appears inside quote marks; also, never treat @ by itself as a file inclusion request. This prevents erratic behavior if a role or database name starts with @. If you need to include a file whose path name contains spaces, you can still do so, but you must write @"/path to/file" rather than putting the quotes around the whole construct. - Prevent infinite loop on some platforms if a directory is named as an inclusion target in "pg_hba.conf" and related files. - Fix possible infinite loop if SSL_read or SSL_write fails without setting errno. This is reportedly possible with some Windows versions of openssl. - Disallow GSSAPI authentication on local connections, since it requires a hostname to function correctly. - Protect ecpg against applications freeing strings unexpectedly. - Make ecpg report the proper SQLSTATE if the connection disappears. - Fix translation of cell contents in psql \d output. - Fix psql's numericlocale option to not format strings it shouldn't in latex and troff output formats. - Fix a small per-query memory leak in psql. - Make psql return the correct exit status (3) when ON_ERROR_STOP and --single-transaction are both specified and an error occurs during the implied "COMMIT". - Fix pg_dump's output of permissions for foreign servers. - Fix possible crash in parallel pg_restore due to out-of-range dependency IDs. - Fix plpgsql failure in one case where a composite column is set to NULL. - Fix possible failure when calling PL/Perl functions from PL/PerlU or vice versa. - Add volatile markings in PL/Python to avoid possible compiler-specific misbehavior> - Ensure PL/Tcl initializes the Tcl interpreter. The only known symptom of this oversight is that the Tcl clock command misbehaves if using Tcl 8.5 or later. - Prevent ExecutorEnd from being run on portals created within a failed transaction or subtransaction. This is known to cause issues when using "contrib/auto_explain". - Prevent crash in "contrib/dblink" when too many key columns are specified to a dblink_build_sql_- function. - Allow zero-dimensional arrays in "contrib/ltree" operations. This case was formerly rejected as an error, but it's more convenient to treat it the same as a zero-element array. In particular this avoids unnecessary failures when an ltree operation is applied to the result of ARRAY(SELECT ...) and the sub-select returns no rows. - Fix assorted crashes in "contrib/xml2" caused by sloppy memory management. Checksums-Sha1: 54d0dd5786b07d9e014b872d28786ee3f21e0218 191668 libpq-dev_8.4.3-0ubuntu9.10_lpia.deb 1d69d0337093465d78d959587e66abc01369696e 1452658 postgresql-8.4_8.4.3-0ubuntu9.10_lpia_translations.tar.gz d17beda3316ef28262ecc42ddf255e5838442219 77996 libpq5_8.4.3-0ubuntu9.10_lpia.deb 1e9c1f5952758ade944d79c8609451e6b3ab753c 32010 libecpg6_8.4.3-0ubuntu9.10_lpia.deb ffd132d4c09af6989d1237fc1c1ab647c786baec 224408 libecpg-dev_8.4.3-0ubuntu9.10_lpia.deb f862ed551bfd1c676d2bc1d5bf93727117c31075 10382 libecpg-compat3_8.4.3-0ubuntu9.10_lpia.deb f545a2d1f596558e5895cb1cd5e731b9ea118da3 43612 libpgtypes3_8.4.3-0ubuntu9.10_lpia.deb ed7fdce3eadd835bad0f36f7b1463e2923779449 3885524 postgresql-8.4_8.4.3-0ubuntu9.10_lpia.deb 649d8f392d44ae4a211958d80b685bc1f9c0d794 782450 postgresql-client-8.4_8.4.3-0ubuntu9.10_lpia.deb 7b9b640c159d3dc291470fb1556d02fa3ae000ed 621144 postgresql-server-dev-8.4_8.4.3-0ubuntu9.10_lpia.deb 3161aca7a0a16aae73d805df588d89d17d3d25eb 368886 postgresql-contrib-8.4_8.4.3-0ubuntu9.10_lpia.deb 0d4922103214339766f5d47da2ff03df8dffa8fa 39626 postgresql-plperl-8.4_8.4.3-0ubuntu9.10_lpia.deb 42cdd52084583a2894f9e43fabf7311532ca9750 32840 postgresql-plpython-8.4_8.4.3-0ubuntu9.10_lpia.deb 61495f250577ac719790108e92e99fb25d121538 31592 postgresql-pltcl-8.4_8.4.3-0ubuntu9.10_lpia.deb Checksums-Sha256: 443900bbb1693ce303c39f8beeaf4526096ed99be53eb51898f77a92732fac86 191668 libpq-dev_8.4.3-0ubuntu9.10_lpia.deb 47c27fa6ae29206ff1f300151ecc2ce4994fe14182a8108353c3bad026de0f6d 1452658 postgresql-8.4_8.4.3-0ubuntu9.10_lpia_translations.tar.gz 739d00829a552c36d8143cf524b8c136086bf944b6f1a1b0ae99b58a5f9ed4f0 77996 libpq5_8.4.3-0ubuntu9.10_lpia.deb a92a244ba2f20f7e649de604efd9d92613d5274048bbfb949033118f5080a558 32010 libecpg6_8.4.3-0ubuntu9.10_lpia.deb b830a2e3bbb8722dd1acee73588e85ea0e15454fc32be459c2c209633a248f50 224408 libecpg-dev_8.4.3-0ubuntu9.10_lpia.deb 283eca4d45adb30fbf40ca67476c6248e028150908486c2c1678f09f3de287c1 10382 libecpg-compat3_8.4.3-0ubuntu9.10_lpia.deb 97e2c3169b9ac639d2bb9fcbbaf640ce3d3ddbff86cc38c8a66e0eda6bd83f51 43612 libpgtypes3_8.4.3-0ubuntu9.10_lpia.deb 4760e358c894f91ad15d625e3037543f430903bbd73547a03963618f40f2c3d6 3885524 postgresql-8.4_8.4.3-0ubuntu9.10_lpia.deb 0a709559bb1be6c36d902e55c7f5f405751d48a94f5df1797025cf856e84793b 782450 postgresql-client-8.4_8.4.3-0ubuntu9.10_lpia.deb a4188c5e81de0c3be68f705ccba2c795d8713b638573baf159a2a09c52c767d2 621144 postgresql-server-dev-8.4_8.4.3-0ubuntu9.10_lpia.deb eb397699671a1ad07245abcc5f6372b26e66836aa6f79f1284dcedbd71caba2e 368886 postgresql-contrib-8.4_8.4.3-0ubuntu9.10_lpia.deb 977be67b7f3fdf40d21130236c500463dd987311bd4e2191830f6b02e2caa20b 39626 postgresql-plperl-8.4_8.4.3-0ubuntu9.10_lpia.deb 6a0829e405da463e7efae242327d7a48a5252ee86b25ac53255dcaa11c888196 32840 postgresql-plpython-8.4_8.4.3-0ubuntu9.10_lpia.deb 0f146cf05b71fdd0bb5a356fb518aaf5e9bb898a81e8231a088e0f52e70f7e80 31592 postgresql-pltcl-8.4_8.4.3-0ubuntu9.10_lpia.deb Files: db6a6affe68072dbd3d1d10c10b8f438 191668 libdevel optional libpq-dev_8.4.3-0ubuntu9.10_lpia.deb 7139542f3f53c2a2f95d4ac922a545f4 1452658 raw-translations - postgresql-8.4_8.4.3-0ubuntu9.10_lpia_translations.tar.gz afe2ac3b345ee877424fb32ad23d881d 77996 libs optional libpq5_8.4.3-0ubuntu9.10_lpia.deb e440e429d8e3b15612529431fccc6ed6 32010 libs optional libecpg6_8.4.3-0ubuntu9.10_lpia.deb 5d956b38aa0cf3c94381e294ba4d0dae 224408 libdevel optional libecpg-dev_8.4.3-0ubuntu9.10_lpia.deb 7002c7958eb5a7efc7e15c8e9ac3d2a1 10382 libs optional libecpg-compat3_8.4.3-0ubuntu9.10_lpia.deb 987986aa5e374e5217e4d142a7167380 43612 libs optional libpgtypes3_8.4.3-0ubuntu9.10_lpia.deb 5eaf150b2fbdc54a71c61c393909433d 3885524 database optional postgresql-8.4_8.4.3-0ubuntu9.10_lpia.deb 6fe640b3b50e4e706dd65884a1cf7fba 782450 database optional postgresql-client-8.4_8.4.3-0ubuntu9.10_lpia.deb 8c126c2018accd3b22ce1aff94271b88 621144 libdevel optional postgresql-server-dev-8.4_8.4.3-0ubuntu9.10_lpia.deb fb65306ba617c577cc6a55953531ea80 368886 database optional postgresql-contrib-8.4_8.4.3-0ubuntu9.10_lpia.deb 1bd425bb6d1f27d1313994fb3359daed 39626 database optional postgresql-plperl-8.4_8.4.3-0ubuntu9.10_lpia.deb 6e1d00dd7525b86d1e8a7d1da631c997 32840 database optional postgresql-plpython-8.4_8.4.3-0ubuntu9.10_lpia.deb 86342bf24cdcc4248c144694c5dbba50 31592 database optional postgresql-pltcl-8.4_8.4.3-0ubuntu9.10_lpia.deb Launchpad-Bugs-Fixed: 557408