Branches for Gutsy

Author: Martin Pitt
Revision Date: 2007-09-28 15:12:33 UTC

* Upload bzr head to Gutsy to get the fix below quickly.
* Add debian/patches/00upstream-tsearch2-compareWORD.patch:
  - Fix tsearch2's compareWORD() function to return 0 on identical strings.
    This avoids endless loops for situations where identical strings appear
    in sort lists (which Should Not Happen™, but do anyway).
  - Patch taken from upstream CVS:
    http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/tsvector.c?r1=1.26&r2=1.26.2.1
  - Thanks to Stuart Bishop for finding the bug and providing a reproducer.
  - (LP: #141637)

Author: Martin Pitt
Revision Date: 2008-11-04 21:22:42 UTC

* 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.

Author: Martin Pitt
Revision Date: 2008-01-11 16:29:39 UTC

* Upload 8.2.6 into gutsy-security.
* Add debian/patches/00upstream-clauseless-joins-regression.patch:
  - Fix a regression of 8.2.6 wrt. large clauseless joins.
  - Taken from upstream CVS:
    http://archives.postgresql.org/pgsql-committers/2008-01/msg00164.php

Author: Martin Pitt
Revision Date: 2008-11-04 21:22:42 UTC

* 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.