Accepted: postgresql-8.2 8.2.9-0ubuntu0.7.04 (source)

Martin Pitt martin.pitt at
Wed Jun 11 20:21:21 BST 2008

 OK: postgresql-8.2_8.2.9.orig.tar.gz
 OK: postgresql-8.2_8.2.9-0ubuntu0.7.04.diff.gz
 OK: postgresql-8.2_8.2.9-0ubuntu0.7.04.dsc
     -> Component: main Section: misc

Hash: SHA1

Format: 1.7
Date: Mon, 09 Jun 2008 17:44:02 +0200
Source: postgresql-8.2
Binary: libpq-dev libpq5 libecpg5 libecpg-dev libecpg-compat2 libpgtypes2 postgresql-8.2 postgresql-client-8.2 postgresql-server-dev-8.2 postgresql-doc-8.2 postgresql-contrib-8.2 postgresql-plperl-8.2 postgresql-plpython-8.2 postgresql-pltcl-8.2
Architecture: source
Version: 8.2.9-0ubuntu0.7.04
Distribution: feisty-proposed
Urgency: low
Maintainer: Martin Pitt <martin.pitt at>
Changed-By: Martin Pitt <martin.pitt at>
 libecpg-compat2 - older version of run-time library for ECPG programs
 libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
 libecpg5   - run-time library for ECPG programs
 libpgtypes2 - shared library libpgtypes for PostgreSQL 8.2
 libpq-dev  - header files for libpq5 (PostgreSQL library)
 libpq5     - PostgreSQL C client library
 postgresql-8.2 - object-relational SQL database, version 8.2 server
 postgresql-client-8.2 - front-end programs for PostgreSQL 8.2
 postgresql-contrib-8.2 - additional facilities for PostgreSQL
 postgresql-doc-8.2 - documentation for the PostgreSQL database management system
 postgresql-plperl-8.2 - PL/Perl procedural language for PostgreSQL 8.2
 postgresql-plpython-8.2 - PL/Python procedural language for PostgreSQL 8.2
 postgresql-pltcl-8.2 - PL/Tcl procedural language for PostgreSQL 8.2
 postgresql-server-dev-8.2 - development files for PostgreSQL 8.2 server-side programming
Launchpad-Bugs-Fixed: 238587
 postgresql-8.2 (8.2.9-0ubuntu0.7.04) feisty-proposed; urgency=low
   * New upstream bug fix release (note that 8.2.8 was never officially
     released due to the discovery of another major bug):
     - Make pg_get_ruledef() parenthesize negative constants.
       Before this fix, a negative constant in a view or rule might be
       dumped as, say, -42::integer, which is subtly incorrect: it should
       be (-42)::integer due to operator precedence rules. Usually this
       would make little difference, but it could interact with another
       recent patch to cause PostgreSQL to reject what had been a valid
       "SELECT DISTINCT" view query. Since this could result in pg_dump
       output failing to reload, it is being treated as a high-priority
     - Make "ALTER AGGREGATE ... OWNER TO" update pg_shdepend.
       This oversight could lead to problems if the aggregate was later
       involved in a "DROP OWNED" or "REASSIGN OWNED" operation.
     - Fix "ALTER TABLE ADD COLUMN ... PRIMARY KEY" so that the new column
       is correctly checked to see if it's been initialized to all
       non-nulls. Previous versions neglected to check this requirement at all.
     - Fix possible "CREATE TABLE" failure when inheriting the "same"
       constraint from multiple parent relations that inherited that
       constraint from a common ancestor.
     - Fix pg_get_ruledef() to show the alias, if any, attached to the
       target table of an "UPDATE" or "DELETE".
     - Fix GIN bug that could result in a too many LWLocks taken failure.
     - Avoid possible crash when decompressing corrupted data.
     - Repair two places where SIGTERM exit of a backend could leave
       corrupted state in shared memory.
     - Fix conversions between ISO-8859-5 and other encodings to handle
       Cyrillic "Yo" characters (e and E with two dots).
     - Fix several datatype input functions, notably array_in(), that were
       allowing unused bytes in their results to contain uninitialized,
       unpredictable values.
       This could lead to failures in which two apparently identical
       literal values were not seen as equal, resulting in the parser
       complaining about unmatched ORDER BY and DISTINCT expressions.
     - Fix a corner case in regular-expression substring matching.
     - Fix incorrect result from ecpg's PGTYPEStimestamp_sub() function.
     - Fix broken GiST comparison function for "contrib/tsearch2"'s
       tsquery type.
     - Fix possible crashes in "contrib/cube" functions.
     - Fix core dump in "contrib/xml2"'s xpath_table() function when the
       input query returns a NULL value.
    (LP: #238587)
 87df24ca08dc34fa9ad2a58c55bbe897 1186 misc optional postgresql-8.2_8.2.9-0ubuntu0.7.04.dsc
 8bf79052d72158d6c7839bfc470bb538 31287 misc optional postgresql-8.2_8.2.9-0ubuntu0.7.04.diff.gz
Original-Maintainer: Martin Pitt <mpitt at>

Version: GnuPG v1.4.6 (GNU/Linux)


More information about the feisty-changes mailing list