Received: from mail.netbsd.org (mail.netbsd.org [204.152.190.11]) by narn.NetBSD.org (Postfix) with ESMTP id D69B663BD86 for ; Tue, 4 Nov 2008 09:52:41 +0000 (UTC) Received: by mail.netbsd.org (Postfix, from userid 0) id 7FAB563B230; Tue, 4 Nov 2008 09:52:41 +0000 (UTC) Received: from cvs.netbsd.org (unknown [IPv6:2001:4f8:4:7:2e0:81ff:fe25:eab4]) by mail.netbsd.org (Postfix) with ESMTP id 0F3CC63B1B4 for ; Tue, 4 Nov 2008 09:52:39 +0000 (UTC) Received: by cvs.netbsd.org (Postfix, from userid 500) id D1C50175D0; Tue, 4 Nov 2008 09:52:39 +0000 (UTC) From: Adam Ciarcinski Subject: CVS commit: pkgsrc/databases To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org Message-Id: <20081104095239.D1C50175D0@cvs.netbsd.org> Date: Tue, 4 Nov 2008 09:52:39 +0000 (UTC) Sender: pkgsrc-changes-owner@NetBSD.org List-Id: pkgsrc-changes Precedence: list 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.