Comment 10 for bug 293758

This bug was fixed in the package postgresql-8.2 - 8.2.11-0ubuntu0.7.10

---------------
postgresql-8.2 (8.2.11-0ubuntu0.7.10) gutsy-proposed; urgency=low

  * New upstream bug fix release 8.2.11: (LP: #293758)
    - Fix GiST index corruption due to marking the wrong index entry
      "dead" after a deletion. This would result in index searches failing to
      find rows they should have found.
    - Fix backend crash when the client encoding cannot represent a
      localized error message.
    - Fix possible crash when deeply nested functions are invoked from a
      trigger.
    - Improve optimization of "expression" IN ("expression-list") queries.
      Cases in which there are query variables on the right-hand side had
      been handled less efficiently in 8.2.x and 8.3.x than in prior
      versions. The fix restores 8.1 behavior for such cases.
    - Fix mis-expansion of rule queries when a sub-SELECT appears in a
      function call in FROM, a multi-row VALUES list, or a RETURNING list.
      The usual symptom of this problem is an "unrecognized node type"
      error.
    - Fix memory leak during rescan of a hashed aggregation plan.
    - Ensure an error is reported when a newly-defined PL/pgSQL trigger
      function is invoked as a normal function.
    - Prevent possible collision of relfilenode numbers when moving a
      table to another tablespace with "ALTER SET TABLESPACE".
    - Fix incorrect tsearch2 headline generation when single query item
      matches first word of text.
    - Fix improper display of fractional seconds in interval values when
      using a non-ISO datestyle.
    - Ensure SPI_getvalue and SPI_getbinval behave correctly when the
      passed tuple and tuple descriptor have different numbers of columns.
      This situation is normal when a table has had columns added or
      removed, but these two functions didn't handle it properly. The
      only likely consequence is an incorrect error indication.
    - Fix ecpg's parsing of "CREATE ROLE".
    - Fix recent breakage of pg_ctl restart.
  * 03-gettext-domains.patch: Unfuzz for new release.

 -- Martin Pitt <email address hidden> Tue, 04 Nov 2008 21:22:42 +0100