[pkgsrc/trunk]: pkgsrc/databases Changes 8.3.8:

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/3d2c877b9ba0
branches:  trunk
changeset: 398881:3d2c877b9ba0
user:      adam <adam%pkgsrc.org@localhost>
date:      Thu Sep 10 10:07:17 2009 +0000

description:
Changes 8.3.8:
* Fix Windows shared-memory allocation code
* Force WAL segment switch during pg_start_backup()
* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
  security-definer functions
* Make "LOAD" of an already-loaded loadable module into a no-op
* Disallow empty passwords during LDAP authentication
* Fix handling of sub-SELECTs appearing in the arguments of an
  outer-level aggregate function
* Fix bugs associated with fetching a whole-row value from the output
  of a Sort or Materialize plan node
* Prevent synchronize_seqscans from changing the results of
  scrollable and WITH HOLD cursors
* Revert planner change that disabled partial-index and constraint
  exclusion optimizations when there were more than 100 clauses in an
  AND or OR list
* Fix hash calculation for data type interval
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with 'HH'/'HH12'
* 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
* Fix money data type to work in locales where currency amounts have
  no fractional digits, e.g. Japan
* Fix LIKE for case where pattern contains %_
* Properly round datetime input like 00:12:57.9999999999999999999999999999
* Fix memory leaks in XML operations
* Fix poor choice of page split point in GiST R-tree operator classes
* Ensure that a "fast shutdown" request will forcibly terminate open
  sessions, even if a "smart shutdown" was already in progress
* Avoid performance degradation in bulk inserts into GIN indexes when
  the input values are (nearly) in sorted order
* Correctly enforce NOT NULL domain constraints in some contexts in
  PL/pgSQL
* Fix portability issues in plperl initialization
* Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is
  empty
* Improve pg_dump's efficiency when there are many large objects
* Use SIGUSR1, not SIGQUIT, as the failover signal for pg_standby

diffstat:

 databases/postgresql83-client/Makefile |  3 +--
 databases/postgresql83-client/PLIST    |  7 ++++++-
 databases/postgresql83/Makefile.common |  5 +++--
 databases/postgresql83/distinfo        |  8 ++++----
 4 files changed, 14 insertions(+), 9 deletions(-)

diffs (103 lines):

diff -r f416a6275239 -r 3d2c877b9ba0 databases/postgresql83-client/Makefile
--- a/databases/postgresql83-client/Makefile    Thu Sep 10 10:06:19 2009 +0000
+++ b/databases/postgresql83-client/Makefile    Thu Sep 10 10:07:17 2009 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2009/06/14 22:57:59 joerg Exp $
+# $NetBSD: Makefile,v 1.8 2009/09/10 10:07:17 adam Exp $
 
 PKGNAME=       postgresql83-client-${BASE_VERS}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 PKG_DESTDIR_SUPPORT=   user-destdir
diff -r f416a6275239 -r 3d2c877b9ba0 databases/postgresql83-client/PLIST
--- a/databases/postgresql83-client/PLIST       Thu Sep 10 10:06:19 2009 +0000
+++ b/databases/postgresql83-client/PLIST       Thu Sep 10 10:07:17 2009 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2009/06/14 22:57:59 joerg Exp $
+@comment $NetBSD: PLIST,v 1.10 2009/09/10 10:07:17 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -1202,6 +1202,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-23.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-24.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-25.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-26.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
@@ -1224,6 +1225,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-19.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-20.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-21.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-22.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
@@ -1242,6 +1244,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-17.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-18.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
@@ -1256,6 +1259,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-13.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-14.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-4.html
@@ -1272,6 +1276,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-6.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-7.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-8.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff -r f416a6275239 -r 3d2c877b9ba0 databases/postgresql83/Makefile.common
--- a/databases/postgresql83/Makefile.common    Thu Sep 10 10:06:19 2009 +0000
+++ b/databases/postgresql83/Makefile.common    Thu Sep 10 10:07:17 2009 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.7 2009/03/20 16:02:41 adam Exp $
+# $NetBSD: Makefile.common,v 1.8 2009/09/10 10:07:17 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -25,6 +25,7 @@
 CONFLICTS+=    postgresql80-*
 CONFLICTS+=    postgresql81-*
 CONFLICTS+=    postgresql82-*
+CONFLICTS+=    postgresql84-*
 
 DISTINFO_FILE?=                ${.CURDIR}/../postgresql83/distinfo
 COMMON_FILESDIR?=      ${.CURDIR}/../postgresql83/files
@@ -37,7 +38,7 @@
 #
 # Note: Do not forget jdbc-postgresql83 when updating version
 #
-DIST_VERS?=            8.3.7
+DIST_VERS?=            8.3.8
 BASE_VERS?=            ${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql83-client+=    postgresql83-client>=${BASE_VERS}
diff -r f416a6275239 -r 3d2c877b9ba0 databases/postgresql83/distinfo
--- a/databases/postgresql83/distinfo   Thu Sep 10 10:06:19 2009 +0000
+++ b/databases/postgresql83/distinfo   Thu Sep 10 10:07:17 2009 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.7 2009/03/20 16:02:41 adam Exp $
+$NetBSD: distinfo,v 1.8 2009/09/10 10:07:17 adam Exp $
 
-SHA1 (postgresql-8.3.7.tar.bz2) = 96facdf7229a7f18f016d86ff6cb350ca5d50bd5
-RMD160 (postgresql-8.3.7.tar.bz2) = 93b9360d83546fff2d5dadfb9ec32ca3ad7984db
-Size (postgresql-8.3.7.tar.bz2) = 14124712 bytes
+SHA1 (postgresql-8.3.8.tar.bz2) = 9af0351cfdac73381bb4b06fb429345fd14930cd
+RMD160 (postgresql-8.3.8.tar.bz2) = 333cbc0b0d9f3f756b08b7e980691dc5671877e5
+Size (postgresql-8.3.8.tar.bz2) = 14147538 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 7bf5635b0b93c3c0d33acd4e122e102c92ce7b76
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279