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: amd64 amd64_translations Version: 8.4.3-0ubuntu9.10 Distribution: karmic-proposed Urgency: low Maintainer: Ubuntu/amd64 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: d5733d9542dbec7687f5cb368ccbf140c468d03a 203018 libpq-dev_8.4.3-0ubuntu9.10_amd64.deb 34e3b6d527df1f30ff0336224c5bfce9034f6a4e 1452730 postgresql-8.4_8.4.3-0ubuntu9.10_amd64_translations.tar.gz d732dfad0f6a81c652e878b6fd1f941ddacc70a4 83820 libpq5_8.4.3-0ubuntu9.10_amd64.deb e0c3872336a0bbd1a60b24570b6626b28dad061e 33472 libecpg6_8.4.3-0ubuntu9.10_amd64.deb 3153a4eba5480ec1d4839d8df3654fae4bdb6b52 241344 libecpg-dev_8.4.3-0ubuntu9.10_amd64.deb 47484afc95fed8727a76a21729b94fdbefe4a505 11506 libecpg-compat3_8.4.3-0ubuntu9.10_amd64.deb 2e1483595d7f00a37de917f55cde2fcf1882593b 44530 libpgtypes3_8.4.3-0ubuntu9.10_amd64.deb b7f5f696b1f116ada07c401dfb8402b47fbf020c 4045564 postgresql-8.4_8.4.3-0ubuntu9.10_amd64.deb c856c587b407c0d30e33f73ef7fdd14e07476b8c 826288 postgresql-client-8.4_8.4.3-0ubuntu9.10_amd64.deb 79bc2bca391839eb779ed2853e4acdd1f33ce5b5 626050 postgresql-server-dev-8.4_8.4.3-0ubuntu9.10_amd64.deb 863979d164ff156952aed67e05fa92000602f8fd 414392 postgresql-contrib-8.4_8.4.3-0ubuntu9.10_amd64.deb 8232102c83c30e57b2918e77de719aca659709d4 40848 postgresql-plperl-8.4_8.4.3-0ubuntu9.10_amd64.deb fbc13cf9a97c22f53cc66401f5c1cf7ef6a4df77 35074 postgresql-plpython-8.4_8.4.3-0ubuntu9.10_amd64.deb a913a128c97e6418a6e6a7a30df31aefa62a0e84 32244 postgresql-pltcl-8.4_8.4.3-0ubuntu9.10_amd64.deb Checksums-Sha256: d4b571214c265d81f4046f76b7da8320731ec7a958761a76b984423fe383a873 203018 libpq-dev_8.4.3-0ubuntu9.10_amd64.deb 96d3fa641e0e07ce223b394327bc605e9696206d6d9c07ce9696ede74f716f5c 1452730 postgresql-8.4_8.4.3-0ubuntu9.10_amd64_translations.tar.gz 57a65dcb53469dd6538f9e0de426380f2585ccf80ee3ed8e49c6be055ba6dde3 83820 libpq5_8.4.3-0ubuntu9.10_amd64.deb 0699dfae3b0fcbdf8de7b5aba199fda56bb044237adff88afd393b2f5a3e20ea 33472 libecpg6_8.4.3-0ubuntu9.10_amd64.deb 196b5c970045e5942228aa4b11ecbace4ef0fc14d2f5b7875f098c8910b3ab5b 241344 libecpg-dev_8.4.3-0ubuntu9.10_amd64.deb 4c020bd9486a3caabcc0705f0175cfe7a8f68f09f120efd40ac40b6355c94268 11506 libecpg-compat3_8.4.3-0ubuntu9.10_amd64.deb 8be4ce33bc0669d46a32d0b80cd9352474635fc2a29e9e86f5409986e5f463d2 44530 libpgtypes3_8.4.3-0ubuntu9.10_amd64.deb 2f1148e47bc1e08a50217b4b678d55ffaaa167b160efa4e30c7f5f5920147a47 4045564 postgresql-8.4_8.4.3-0ubuntu9.10_amd64.deb dbb6f24c131d3cf01eb80fd9724799f4ca4d3a1336b3ec8b63408f30120cbd94 826288 postgresql-client-8.4_8.4.3-0ubuntu9.10_amd64.deb 9005d9b5d1c9278422357e2ef8362f4187bfdbfa550a47fa63784b8291189c5d 626050 postgresql-server-dev-8.4_8.4.3-0ubuntu9.10_amd64.deb f79b43d2eef477df6682a55bc450d7ab5f5ad28470e136597f5f78a80c78d79b 414392 postgresql-contrib-8.4_8.4.3-0ubuntu9.10_amd64.deb e6d5d6767a6882229dfac102218d62e8d60f4d431abab31d9a64b66de23a54e7 40848 postgresql-plperl-8.4_8.4.3-0ubuntu9.10_amd64.deb 61f6059d020447cc7f021be526a216efb1dee0f50c45128dc5a16679e7210112 35074 postgresql-plpython-8.4_8.4.3-0ubuntu9.10_amd64.deb b2a5b71315fc55747c6912aa864fc121997dd664fae60fa912bfc478e77127b1 32244 postgresql-pltcl-8.4_8.4.3-0ubuntu9.10_amd64.deb Files: cc99e6ed456d9726d4a658a994345f7c 203018 libdevel optional libpq-dev_8.4.3-0ubuntu9.10_amd64.deb 8a48b8e79ff0e5b6c22d7c4b4bdecdce 1452730 raw-translations - postgresql-8.4_8.4.3-0ubuntu9.10_amd64_translations.tar.gz 537d68634ad15afc321bd41996f07153 83820 libs optional libpq5_8.4.3-0ubuntu9.10_amd64.deb f1c4a6938fa40d27c898b876b49c096b 33472 libs optional libecpg6_8.4.3-0ubuntu9.10_amd64.deb 1e490a7d56d0d35172f776a608f1354a 241344 libdevel optional libecpg-dev_8.4.3-0ubuntu9.10_amd64.deb 58d901c1248805d7f8831244c4208d09 11506 libs optional libecpg-compat3_8.4.3-0ubuntu9.10_amd64.deb eb8b62bbcf9b1e91f9ffd630da65de13 44530 libs optional libpgtypes3_8.4.3-0ubuntu9.10_amd64.deb 8b6574fa1512b1922c4533cec5ed9aa6 4045564 database optional postgresql-8.4_8.4.3-0ubuntu9.10_amd64.deb 47ea6cf1a01ca5785797f96e4fbba556 826288 database optional postgresql-client-8.4_8.4.3-0ubuntu9.10_amd64.deb a82d00cb1b83409b279adbf64bba8ab0 626050 libdevel optional postgresql-server-dev-8.4_8.4.3-0ubuntu9.10_amd64.deb 5b337d4644ac5870c9f5dd1ca5a1a8f0 414392 database optional postgresql-contrib-8.4_8.4.3-0ubuntu9.10_amd64.deb 0ea0af81945ecefb60e8377a7bbc72f9 40848 database optional postgresql-plperl-8.4_8.4.3-0ubuntu9.10_amd64.deb 047ff1430f2bf0c88bdaaf64ed2d566a 35074 database optional postgresql-plpython-8.4_8.4.3-0ubuntu9.10_amd64.deb 1c07a2bce0a2b10e1ebe49cdab105d8c 32244 database optional postgresql-pltcl-8.4_8.4.3-0ubuntu9.10_amd64.deb Launchpad-Bugs-Fixed: 557408