postgresql-8.1 8.1.18-0ubuntu0.6.06 source package in Ubuntu

Changelog

postgresql-8.1 (8.1.18-0ubuntu0.6.06) dapper-security; urgency=low

  * New upstream bug fix/security release: (LP: #430544)
    - Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
      security-definer functions.
      This covers a case that was missed in the previous patch that
      disallowed "SET ROLE" and "SET SESSION AUTHORIZATION" inside
      security-definer functions. (See CVE-2007-6600)
    - Fix handling of sub-SELECTs appearing in the arguments of an
      outer-level aggregate function.
    - Fix hash calculation for data type interval.
      This corrects wrong results for hash joins on interval values. It
      also changes the contents of hash indexes on interval columns. If
      you have any such indexes, you must "REINDEX" them after updating.
    - Treat to_char(..., 'TH') as an uppercase ordinal suffix with
      'HH'/'HH12'
      It was previously handled as 'th' (lowercase).
    - Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
      and integer datetimes are in use.
    - Fix calculation of distance between a point and a line segment.
      This led to incorrect results from a number of geometric operators.
    - Fix money data type to work in locales where currency amounts have
      no fractional digits, e.g. Japan.
    - Properly round datetime input like
      00:12:57.9999999999999999999999999999
    - Fix poor choice of page split point in GiST R-tree operator classes
    - Fix portability issues in plperl initialization
    - Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is
      empty
    - Fix "contrib/xml2"'s xslt_process() to properly handle the maximum
      number of parameters (twenty)
    - Improve robustness of libpq's code to recover from errors during
      "COPY FROM STDIN"
    - Avoid including conflicting readline and editline header files when
      both libraries are installed

 -- Martin Pitt <email address hidden>   Wed, 16 Sep 2009 08:30:31 +0000