[ubuntu/jaunty] postgresql-8.3 8.3.6-1 (Accepted)

Fri Feb 6 22:40:14 GMT 2009

postgresql-8.3 (8.3.6-1) unstable; urgency=low

  * New upstream bug fix release:
    - Make "DISCARD ALL" release advisory locks, in addition to
      everything it already did. This was decided to be the most
      appropriate behavior. This could affect existing applications,
      however.
    - Fix whole-index GiST scans to work correctly.  This error could
      cause rows to be lost if a table is clustered on a GiST index.
    - Fix crash of xmlconcat(NULL).
    - Fix possible crash in ispell dictionary if high-bit-set characters
      are used as flags.  This is known to be done by one widely
      available Norwegian dictionary, and the same condition may exist
      in others. (Closes: #513580)
    - Fix misordering of pg_dump output for composite types.  The most
      likely problem was for user-defined operator classes to be
      dumped after indexes or views that needed them.
    - Improve handling of URLs in headline() function.
    - Improve handling of overlength headlines in headline() function.
    - Prevent possible Assert failure or misconversion if an encoding
      conversion is created with the wrong conversion function for the
      specified pair of encodings.
    - Fix possible Assert failure if a statement executed in PL/pgSQL is
      rewritten into another kind of statement, for example if an
      "INSERT" is rewritten into an "UPDATE".
    - Ensure that a snapshot is available to datatype input functions.
      This primarily affects domains that are declared with CHECK
      constraints involving user-defined stable or immutable functions.
      Such functions typically fail if no snapshot has been set.
    - Make it safer for SPI-using functions to be used within datatype
      I/O; in particular, to be used in domain check constraints.
    - Avoid unnecessary locking of small tables in "VACUUM".
    - Fix a problem that sometimes kept "ALTER TABLE ENABLE/DISABLE RULE"
      from being recognized by active sessions.
    - Fix a problem that made UPDATE RETURNING tableoid return zero
      instead of the correct OID.
    - Allow functions declared as taking ANYARRAY to work on the
      pg_statistic columns of that type.
      This used to work, but was unintentionally broken in 8.3.
    - Fix planner misestimation of selectivity when transitive equality
      is applied to an outer-join clause.
      This could result in bad plans for queries like ... from a left
      join b on a.a1 = b.b1 where a.a1 = 42 ...
    - Improve optimizer's handling of long IN lists.  This change
      avoids wasting large amounts of time on such lists when
      constraint exclusion is enabled.
    - Prevent synchronous scan during GIN index build.  Because GIN is
      optimized for inserting tuples in increasing TID order, choosing
      to use a synchronous scan could slow the build by a factor of
      three or more.
    - Ensure that the contents of a holdable cursor don't depend on the
      contents of TOAST tables.  Previously, large field values in a
      cursor result might be represented as TOAST pointers, which
      would fail if the referenced table got dropped before the cursor
      is read, or if the large value is deleted and then vacuumed
      away. This cannot happen with an ordinary cursor, but it could
      with a cursor that is held past its creating transaction.
    - Fix memory leak when a set-returning function is terminated without
      reading its whole result.
    - Fix encoding conversion problems in XML functions when the database
      encoding isn't UTF-8.
    - Fix "contrib/dblink"'s dblink_get_result(text,bool) function.
    - Fix possible garbage output from "contrib/sslinfo" functions.
    - Fix incorrect behavior of "contrib/tsearch2" compatibility trigger
      when it's fired more than once in a command.
    - Fix possible mis-signaling in autovacuum.
    - Fix ecpg's handling of varchar structs.
    - Make all documentation reference pgsql-bugs and/or pgsql-hackers as
      appropriate, instead of the now-decommissioned pgsql-ports and
      pgsql-patches mailing lists.

Date: Fri, 06 Feb 2009 23:10:40 +0100
Changed-By: Martin Pitt <mpitt at debian.org>
Signed-By: Martin Pitt <martin.pitt at ubuntu.com>
Origin: debian/unstable
https://launchpad.net/ubuntu/jaunty/+source/postgresql-8.3/8.3.6-1
-------------- next part --------------
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Origin: debian/unstable
Format: 1.8
Date: Fri, 06 Feb 2009 23:10:40 +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: source
Version: 8.3.6-1
Distribution: jaunty
Urgency: low
Maintainer: Martin Pitt <mpitt at debian.org>
Changed-By: Martin Pitt <mpitt at debian.org>
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 (supported version)
 postgresql-8.3 - object-relational SQL database, version 8.3 server
 postgresql-client - front-end programs for PostgreSQL (supported version)
 postgresql-client-8.3 - front-end programs for PostgreSQL 8.3
 postgresql-contrib - additional facilities for PostgreSQL (supported 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
Closes: 513580
Changes: 
 postgresql-8.3 (8.3.6-1) unstable; urgency=low
 .
   * New upstream bug fix release:
     - Make "DISCARD ALL" release advisory locks, in addition to
       everything it already did. This was decided to be the most
       appropriate behavior. This could affect existing applications,
       however.
     - Fix whole-index GiST scans to work correctly.  This error could
       cause rows to be lost if a table is clustered on a GiST index.
     - Fix crash of xmlconcat(NULL).
     - Fix possible crash in ispell dictionary if high-bit-set characters
       are used as flags.  This is known to be done by one widely
       available Norwegian dictionary, and the same condition may exist
       in others. (Closes: #513580)
     - Fix misordering of pg_dump output for composite types.  The most
       likely problem was for user-defined operator classes to be
       dumped after indexes or views that needed them.
     - Improve handling of URLs in headline() function.
     - Improve handling of overlength headlines in headline() function.
     - Prevent possible Assert failure or misconversion if an encoding
       conversion is created with the wrong conversion function for the
       specified pair of encodings.
     - Fix possible Assert failure if a statement executed in PL/pgSQL is
       rewritten into another kind of statement, for example if an
       "INSERT" is rewritten into an "UPDATE".
     - Ensure that a snapshot is available to datatype input functions.
       This primarily affects domains that are declared with CHECK
       constraints involving user-defined stable or immutable functions.
       Such functions typically fail if no snapshot has been set.
     - Make it safer for SPI-using functions to be used within datatype
       I/O; in particular, to be used in domain check constraints.
     - Avoid unnecessary locking of small tables in "VACUUM".
     - Fix a problem that sometimes kept "ALTER TABLE ENABLE/DISABLE RULE"
       from being recognized by active sessions.
     - Fix a problem that made UPDATE RETURNING tableoid return zero
       instead of the correct OID.
     - Allow functions declared as taking ANYARRAY to work on the
       pg_statistic columns of that type.
       This used to work, but was unintentionally broken in 8.3.
     - Fix planner misestimation of selectivity when transitive equality
       is applied to an outer-join clause.
       This could result in bad plans for queries like ... from a left
       join b on a.a1 = b.b1 where a.a1 = 42 ...
     - Improve optimizer's handling of long IN lists.  This change
       avoids wasting large amounts of time on such lists when
       constraint exclusion is enabled.
     - Prevent synchronous scan during GIN index build.  Because GIN is
       optimized for inserting tuples in increasing TID order, choosing
       to use a synchronous scan could slow the build by a factor of
       three or more.
     - Ensure that the contents of a holdable cursor don't depend on the
       contents of TOAST tables.  Previously, large field values in a
       cursor result might be represented as TOAST pointers, which
       would fail if the referenced table got dropped before the cursor
       is read, or if the large value is deleted and then vacuumed
       away. This cannot happen with an ordinary cursor, but it could
       with a cursor that is held past its creating transaction.
     - Fix memory leak when a set-returning function is terminated without
       reading its whole result.
     - Fix encoding conversion problems in XML functions when the database
       encoding isn't UTF-8.
     - Fix "contrib/dblink"'s dblink_get_result(text,bool) function.
     - Fix possible garbage output from "contrib/sslinfo" functions.
     - Fix incorrect behavior of "contrib/tsearch2" compatibility trigger
       when it's fired more than once in a command.
     - Fix possible mis-signaling in autovacuum.
     - Fix ecpg's handling of varchar structs.
     - Make all documentation reference pgsql-bugs and/or pgsql-hackers as
       appropriate, instead of the now-decommissioned pgsql-ports and
       pgsql-patches mailing lists.
Checksums-Sha1: 
 3d36f5f527bb165859c8b3bcc19a393407288df3 1641 postgresql-8.3_8.3.6-1.dsc
 8ab4b96b934df73f1e8fafcd57afd186c66eb1ba 13768971 postgresql-8.3_8.3.6.orig.tar.gz
 14afee3c42a2f49811623327ae0dbb73e2697bcd 63469 postgresql-8.3_8.3.6-1.diff.gz
Checksums-Sha256: 
 184720fbb8ffff89eb4dffe5b58c6b59e7effea6da5b8585d329e1179d2e1182 1641 postgresql-8.3_8.3.6-1.dsc
 61ef8d10fcd9bd66a892b3b435fe9dc5a0cef33a3594f8106a22df8ef254a0d3 13768971 postgresql-8.3_8.3.6.orig.tar.gz
 5b2d729a0b20c7c6b81795a89aabb0c7bb723d3c7b88f8278d19410b7f3984e8 63469 postgresql-8.3_8.3.6-1.diff.gz
Files: 
 3cf0365da88a0138fedee18f66b02938 1641 misc optional postgresql-8.3_8.3.6-1.dsc
 7968c46d9f341b8f604fa980bd750f2c 13768971 misc optional postgresql-8.3_8.3.6.orig.tar.gz
 7535140d496c6150857f8e08603c6212 63469 misc optional postgresql-8.3_8.3.6-1.diff.gz

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkmMu6YACgkQDecnbV4Fd/LKuACfZwKtDQnm2MMXVoX8Wa8NzJvg
me4An3V5dkvpZ+6ExUZbr7FYHNlFAdo5
=156t
-----END PGP SIGNATURE-----