lp:ubuntu/intrepid/postgresql-8.2

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

22. By Martin Pitt on 2008-04-22

Bump build dependency libpq-dev to a version which depends on libpq5, to
unbreak backports. Thanks to Gerfried Fuchs! (Closes: #474363)

21. By Martin Pitt on 2008-03-16

* New upstream bug fix release:
  - Repair potential deadlock between concurrent "VACUUM FULL"
    operations on different system catalogs.
  - Fix longstanding "LISTEN"/"NOTIFY" race condition.
  - Disallow "LISTEN" and "UNLISTEN" within a prepared transaction.
    This was formerly allowed but trying to do it had various
    unpleasant consequences, notably that the originating backend could
    not exit as long as an "UNLISTEN" remained uncommitted.
  - Disallow dropping a temporary table within a prepared transaction
    This was correctly disallowed by 8.1, but the check was
    inadvertently broken in 8.2.
  - Fix rare crash when an error occurs during a query using a hash
    index.
  - Fix memory leaks in certain usages of set-returning functions.
  - Fix input of datetime values for February 29 in years BC.
  - Fix "unrecognized node type" error in some variants of "ALTER
    OWNER".
  - Ensure pg_stat_activity.waiting flag is cleared when a lock wait is
    aborted.
  - Fix pg_ctl to correctly extract the postmaster's port number from
    command-line options.(See #358546)
  - Use "-fwrapv" to defend against possible misoptimization in recent
    gcc versions.
  - Correctly enforce statement_timeout values longer than INT_MAX
    microseconds (about 35 minutes).
  - Fix "unexpected PARAM_SUBLINK ID" planner error when
    constant-folding simplifies a sub-select.
  - Fix logical errors in constraint-exclusion handling of IS NULL and
    NOT expressions.
  - Fix another cause of "failed to build any N-way joins" planner
    errors.
  - Fix incorrect constant propagation in outer-join planning.
  - Fix display of constant expressions in ORDER BY and GROUP BY.
  - Fix libpq to handle NOTICE messages correctly during COPY OUT.
* debian/watch: Update for currently working mirror. (Closes: #462823)

20. By Martin Pitt on 2008-01-20

* debian/control: Do not build the versionless metapackages any more, they
  are now built by postgresql-8.3 (which also becomes the default now).
* Drop the client-side libraries, they are built from postgresql-8.3 now.
* Add build dependency libpq-dev, so that dpkg-shlibdeps can find
  libpq.so.5.

19. By Martin Pitt on 2008-01-04

* New upstream security/bugfix release:
  - Prevent functions in indexes from executing with the privileges of
    the user running "VACUUM", "ANALYZE", etc. "SET ROLE" is now forbidden
    within a SECURITY DEFINER context. [CVE-2007-6600]
  - Suitably crafted regular-expression patterns could cause crashes,
    infinite or near-infinite looping, and/or massive memory
    consumption, all of which pose denial-of-service hazards for
    applications that accept regex search patterns from untrustworthy
    sources. [CVE-2007-4769, CVE-2007-4772, CVE-2007-6067]
  - Require non-superusers who use "/contrib/dblink" to use only
    password authentication, as a security measure.
    The fix that appeared for this in 8.2.5 was incomplete, as it
    plugged the hole for only some "dblink" functions. [CVE-2007-6601,
    CVE-2007-3278]
  - Fix bugs in WAL replay for GIN indexes.
  - Fix GIN index build to work properly when maintenance_work_mem is
    4GB or more.
  - Improve planner's handling of LIKE/regex estimation in non-C
    locales.
  - Fix planning-speed problem for deep outer-join nests, as well as
    possible poor choice of join order.
  - Fix planner failure in some cases of WHERE false AND var IN (SELECT
    ...).
  - Make "CREATE TABLE ... SERIAL" and "ALTER SEQUENCE ... OWNED BY"
    not change the currval() state of the sequence.
  - Preserve the tablespace and storage parameters of indexes that are
    rebuilt by "ALTER TABLE ... ALTER COLUMN TYPE".
  - Make archive recovery always start a new WAL timeline, rather than
    only when a recovery stop time was used. This avoids a corner-case risk
    of trying to overwrite an existing archived copy of the last WAL
    segment, and seems simpler and cleaner than the original definition.
  - Make "VACUUM" not use all of maintenance_work_mem when the table is
    too small for it to be useful.
  - Fix potential crash in translate() when using a multibyte database
    encoding.
  - Make corr() return the correct result for negative correlation
    values.
  - Fix overflow in extract(epoch from interval) for intervals
    exceeding 68 years.
  - Fix PL/Perl to not fail when a UTF-8 regular expression is used in
    a trusted function.
  - Fix PL/Python to work correctly with Python 2.5 on 64-bit machines
    (Marko Kreen)
  - Fix PL/Python to not crash on long exception messages.
  - Fix pg_dump to correctly handle inheritance child tables that have
    default expressions different from their parent's.
  - Fix libpq crash when PGPASSFILE refers to a file that is not a
    plain file.
  - ecpg parser fixes.
  - Make "contrib/tablefunc"'s crosstab() handle NULL rowid as a
    category in its own right, rather than crashing.
  - Fix tsvector and tsquery output routines to escape backslashes
    correctly. (LP: #146382)
  - Fix crash of to_tsvector() on huge input strings.
* Drop debian/patches/00upstream-tsearch2-compareWORD.patch, upstream.
* Ship pg_config in postgresql-server-dev, and ship a copy in /usr/bin in
  libpq-dev, instead of libpq-dev shipping it in
  /usr/lib/postgresql/<version>/bin. This makes it possible to use a
  libpq-dev from a different major version (like 8.3 from experimental).
  (Closes: #455509)
* Bump Standards-Version to 3.7.3 (no changes necessary).

18. By Martin Pitt on 2007-12-04

* debian/rules:
  - Build with -O1 on sparc and alpha until the miscompilation with -O2 is
    sorted out (http://lists.debian.org/debian-alpha/2007/11/msg00025.html).
  - Have a failed test suite fail the build on all architectures again.

17. By Martin Pitt on 2007-11-21

* debian/rules:
  - Ignore test suite failure on alpha for now, since it behaves weird on
    some floating point operations (regression in glibc and gcc-4.2). Bug is
    under investigation, but this should not block testing migration for all
    architectures.
  - Remove test suite ignoring for mips and mipsel again, seems the buildds
    finally got a fixed kernel.

16. By Martin Pitt on 2007-10-21

* 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)
* debian/postgresql-8.2.postrm:
  - Clean up rotated logs on purge when postgresql-common is already gone.
    (Closes: #447287)
  - Clean up default data dir/log file if 'pgdata'/'log' symbolic links do
    not exist.
  - Clean up environment file.

15. By Martin Pitt on 2007-09-28

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

14. By Martin Pitt on 2007-09-16

* New upstream bugfix release:
  - Require non-superusers who use "/contrib/dblink" to use only
    password authentication, as a security measure.
    [CVE-2007-3278, CVE-2007-3280]
  - Fix ALTER DOMAIN ADD CONSTRAINT for cases involving domains over
    domains.
  - Make "CREATE DOMAIN ... DEFAULT NULL" work properly.
  - Fix some planner problems with outer joins, notably poor size
    estimation for t1 LEFT JOIN t2 WHERE t2.col IS NULL.
  - Allow the interval data type to accept input consisting only of
    milliseconds or microseconds.
  - Allow timezone name to appear before the year in timestamp input.
  - Fixes for GIN indexes used by "/contrib/tsearch2".
  - Speed up rtree index insertion.
  - Fix excessive logging of SSL error messages.
  - Fix logging so that log messages are never interleaved when using
    the syslogger process.
  - Fix crash when log_min_error_statement logging runs out of memory.
  - Fix incorrect handling of some foreign-key corner cases.
  - Fix stddev_pop(numeric) and var_pop(numeric).
  - Prevent "REINDEX" and "CLUSTER" from failing due to attempting to
    process temporary tables of other sessions.
  - Restrict "/contrib/pgstattuple" functions to superusers, for
    security reasons.
  - Do not let "/contrib/intarray" try to make its GIN opclass the
    default (this caused problems at dump/restore).
* Remove debian/patches/00upstream-01-polymorphic-functions.patch: Upstream
  now.

13. By Martin Pitt on 2007-08-04

* Urgency medium since the dpkg bug above is nasty and I want this fixed in
  testing ASAP.
* debian/postgresql-8.2.postinst: Work around dpkg bug #435938 by manually
  doing the timezone symlink transition. Closes: #430524
* debian/rules: Make binary-arch idempotent if test suite fails.
  Closes: #431565