CVS commit: pkgsrc/databases

[Adam Ciarcinski <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Nov  4 09:52:39 UTC 2008

Modified Files:
        pkgsrc/databases/postgresql82: Makefile.common distinfo
        pkgsrc/databases/postgresql82-client: PLIST
        pkgsrc/databases/postgresql82-plperl: Makefile
        pkgsrc/databases/postgresql82-server: PLIST

Log Message:
Changes 8.2.11:
* 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.
  We have addressed similar issues before, but it would still fail if
  the "character has no equivalent" message itself couldn't be
  converted. The fix is to disable localization and send the plain
  ASCII error message when we detect such a situation.
* 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.
* 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".
  The command tried to re-use the existing filename, instead of
  picking one that is known unused in the destination directory.
* 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 in an "--enable-integer-datetimes" build.
* Ensure SPI_getvalue and SPI_getbinval behave correctly when the
  passed tuple and tuple descriptor have different numbers of columns.
* Fix ecpg's parsing of "CREATE ROLE".
* Fix recent breakage of pg_ctl restart.
* Ensure "pg_control" is opened in binary mode.
  pg_controldata and pg_resetxlog did this incorrectly, and so could
  fail on Windows.
* Update time zone data files to tzdata release 2008i (for DST law
  changes in Argentina, Brazil, Mauritius, Syria)


To generate a diff of this commit:
cvs rdiff -r1.13 -r1.14 pkgsrc/databases/postgresql82/Makefile.common \
    pkgsrc/databases/postgresql82/distinfo
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/postgresql82-client/PLIST
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/postgresql82-plperl/Makefile
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/postgresql82-server/PLIST

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.