pkgsrc-Changes-HG archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

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



details:   https://anonhg.NetBSD.org/pkgsrc/rev/75eb28d8a105
branches:  trunk
changeset: 554044:75eb28d8a105
user:      adam <adam%pkgsrc.org@localhost>
date:      Sat Feb 07 17:55:42 2009 +0000

description:
Changes 8.3.6:
* Make "DISCARD ALL" release advisory locks, in addition to
  everything it already did
  This was decided to be the most appropriate behavior. This could
  affect existing applications, however.
* Fix whole-index GiST scans to work correctly
  This error could cause rows to be lost if a table is clustered on a
  GiST index.
* Fix crash of xmlconcat(NULL)
* Fix possible crash in ispell dictionary if high-bit-set characters
  are used as flags
  This is known to be done by one widely available Norwegian
  dictionary, and the same condition may exist in others.
* Fix misordering of pg_dump output for composite types
  The most likely problem was for user-defined operator classes to be
  dumped after indexes or views that needed them.
* Improve handling of URLs in headline() function
* Improve handling of overlength headlines in headline() function
* Prevent possible Assert failure or misconversion if an encoding
  conversion is created with the wrong conversion function for the
  specified pair of encodings
* Fix possible Assert failure if a statement executed in PL/pgSQL is
  rewritten into another kind of statement, for example if an
  "INSERT" is rewritten into an "UPDATE"
* Ensure that a snapshot is available to datatype input functions
* Make it safer for SPI-using functions to be used within datatype
  I/O; in particular, to be used in domain check constraints
* Avoid unnecessary locking of small tables in "VACUUM"
* Fix a problem that sometimes kept "ALTER TABLE ENABLE/DISABLE RULE"
  from being recognized by active sessions
* Fix a problem that made UPDATE RETURNING tableoid return zero
  instead of the correct OID
* Allow functions declared as taking ANYARRAY to work on the
  pg_statistic columns of that type
  This used to work, but was unintentionally broken in 8.3.
* Fix planner misestimation of selectivity when transitive equality
  is applied to an outer-join clause
  This could result in bad plans for queries like ... from a left
  join b on a.a1 = b.b1 where a.a1 = 42 ...
* Improve optimizer's handling of long IN lists
  This change avoids wasting large amounts of time on such lists when
  constraint exclusion is enabled.
* Prevent synchronous scan during GIN index build
  Because GIN is optimized for inserting tuples in increasing TID
  order, choosing to use a synchronous scan could slow the build by a
  factor of three or more.
* Ensure that the contents of a holdable cursor don't depend on the
  contents of TOAST tables
* Fix memory leak when a set-returning function is terminated without
  reading its whole result
* Fix encoding conversion problems in XML functions when the database
  encoding isn't UTF-8
* Fix "contrib/dblink"'s dblink_get_result(text,bool) function
* Fix possible garbage output from "contrib/sslinfo" functions
* Fix incorrect behavior of "contrib/tsearch2" compatibility trigger
  when it's fired more than once in a command
* Fix possible mis-signaling in autovacuum
* Support running as a service on Windows 7 beta
* Fix ecpg's handling of varchar structs
* Fix configure script to properly report failure when unable to
  obtain linkage information for PL/Perl
* Make all documentation reference pgsql-bugs and/or pgsql-hackers as
  appropriate, instead of the now-decommissioned pgsql-ports and
  pgsql-patches mailing lists
* Update time zone data files to tzdata release 2009a (for Kathmandu
  and historical DST corrections in Switzerland, Cuba)

diffstat:

 databases/postgresql83-client/PLIST     |   7 ++++++-
 databases/postgresql83-server/Makefile  |   3 +--
 databases/postgresql83-server/PLIST     |   3 ++-
 databases/postgresql83/Makefile.common  |   4 ++--
 databases/postgresql83/distinfo         |  12 ++++++------
 databases/postgresql83/patches/patch-aa |   9 +++++----
 databases/postgresql83/patches/patch-ab |  10 +++++-----
 7 files changed, 27 insertions(+), 21 deletions(-)

diffs (161 lines):

diff -r 65995ccb0e7c -r 75eb28d8a105 databases/postgresql83-client/PLIST
--- a/databases/postgresql83-client/PLIST       Sat Feb 07 17:51:59 2009 +0000
+++ b/databases/postgresql83-client/PLIST       Sat Feb 07 17:55:42 2009 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2008/11/04 09:52:50 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2009/02/07 17:55:42 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -1200,6 +1200,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-21.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-22.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
@@ -1220,6 +1221,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-18.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
@@ -1236,6 +1238,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-14.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
@@ -1248,6 +1251,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-10.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-4.html
@@ -1262,6 +1266,7 @@
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-4.html
 ${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.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff -r 65995ccb0e7c -r 75eb28d8a105 databases/postgresql83-server/Makefile
--- a/databases/postgresql83-server/Makefile    Sat Feb 07 17:51:59 2009 +0000
+++ b/databases/postgresql83-server/Makefile    Sat Feb 07 17:55:42 2009 +0000
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.2 2008/11/11 13:50:50 joerg Exp $
+# $NetBSD: Makefile,v 1.3 2009/02/07 17:55:42 adam Exp $
 
 PKGNAME=       postgresql83-server-${BASE_VERS}
 COMMENT=       PostgreSQL database server programs
-PKGREVISION=   1
 
 PKG_DESTDIR_SUPPORT=   user-destdir
 
diff -r 65995ccb0e7c -r 75eb28d8a105 databases/postgresql83-server/PLIST
--- a/databases/postgresql83-server/PLIST       Sat Feb 07 17:51:59 2009 +0000
+++ b/databases/postgresql83-server/PLIST       Sat Feb 07 17:55:42 2009 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2008/11/04 09:52:50 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2009/02/07 17:55:42 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -321,6 +321,7 @@
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kamchatka
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Karachi
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kashgar
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kathmandu
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Katmandu
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Kolkata
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Krasnoyarsk
diff -r 65995ccb0e7c -r 75eb28d8a105 databases/postgresql83/Makefile.common
--- a/databases/postgresql83/Makefile.common    Sat Feb 07 17:51:59 2009 +0000
+++ b/databases/postgresql83/Makefile.common    Sat Feb 07 17:55:42 2009 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.5 2008/11/04 09:52:50 adam Exp $
+# $NetBSD: Makefile.common,v 1.6 2009/02/07 17:55:42 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -37,7 +37,7 @@
 #
 # Note: Do not forget jdbc-postgresql83 when updating version
 #
-DIST_VERS?=            8.3.5
+DIST_VERS?=            8.3.6
 BASE_VERS?=            ${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql83-client+=    postgresql83-client>=${BASE_VERS}
diff -r 65995ccb0e7c -r 75eb28d8a105 databases/postgresql83/distinfo
--- a/databases/postgresql83/distinfo   Sat Feb 07 17:51:59 2009 +0000
+++ b/databases/postgresql83/distinfo   Sat Feb 07 17:55:42 2009 +0000
@@ -1,10 +1,10 @@
-$NetBSD: distinfo,v 1.5 2008/11/04 09:52:50 adam Exp $
+$NetBSD: distinfo,v 1.6 2009/02/07 17:55:42 adam Exp $
 
-SHA1 (postgresql-8.3.5.tar.bz2) = 7615fea044473410b9985dc76a8046d715a620b1
-RMD160 (postgresql-8.3.5.tar.bz2) = d70eec56c2498ba83319f21e818463a113f3540b
-Size (postgresql-8.3.5.tar.bz2) = 14052114 bytes
-SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
-SHA1 (patch-ab) = 61ed51b483b84c3ca88f8955713dff27f9070a6c
+SHA1 (postgresql-8.3.6.tar.bz2) = 6ef6d564988209e5c85b061c71af58bebac522bd
+RMD160 (postgresql-8.3.6.tar.bz2) = fa30a5e426ffd4800bd918012e0094c56ad1bae1
+Size (postgresql-8.3.6.tar.bz2) = 14081040 bytes
+SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
+SHA1 (patch-ab) = 7bf5635b0b93c3c0d33acd4e122e102c92ce7b76
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279
 SHA1 (patch-ad) = 5612e447bbb76e81f72d39ad0153b9f77d47f653
 SHA1 (patch-ae) = 8b3e47320dfe05d94b769c9b079fd7ca6d26f5d6
diff -r 65995ccb0e7c -r 75eb28d8a105 databases/postgresql83/patches/patch-aa
--- a/databases/postgresql83/patches/patch-aa   Sat Feb 07 17:51:59 2009 +0000
+++ b/databases/postgresql83/patches/patch-aa   Sat Feb 07 17:55:42 2009 +0000
@@ -1,8 +1,8 @@
-$NetBSD: patch-aa,v 1.1.1.1 2008/03/04 12:41:37 adam Exp $
+$NetBSD: patch-aa,v 1.2 2009/02/07 17:55:42 adam Exp $
 
---- config/perl.m4.orig        2003-11-30 04:51:17.000000000 +0900
+--- config/perl.m4.orig        2008-11-12 01:00:29.000000000 +0100
 +++ config/perl.m4
-@@ -28,8 +28,6 @@ AC_DEFUN([PGAC_CHECK_PERL_CONFIGS],
+@@ -28,9 +28,7 @@ AC_DEFUN([PGAC_CHECK_PERL_CONFIGS],
  AC_DEFUN([PGAC_CHECK_PERL_EMBED_LDFLAGS],
  [AC_REQUIRE([PGAC_PATH_PERL])
  AC_MSG_CHECKING(for flags to link embedded Perl)
@@ -11,4 +11,5 @@
 -perl_embed_ldflags=`echo X"$pgac_tmp1" | sed "s/^X//;s%$pgac_tmp2%%"`
 +perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
  AC_SUBST(perl_embed_ldflags)dnl
- AC_MSG_RESULT([$perl_embed_ldflags])])
+ if test -z "$perl_embed_ldflags" ; then
+       AC_MSG_RESULT(no)
diff -r 65995ccb0e7c -r 75eb28d8a105 databases/postgresql83/patches/patch-ab
--- a/databases/postgresql83/patches/patch-ab   Sat Feb 07 17:51:59 2009 +0000
+++ b/databases/postgresql83/patches/patch-ab   Sat Feb 07 17:55:42 2009 +0000
@@ -1,6 +1,6 @@
-$NetBSD: patch-ab,v 1.3 2008/06/20 06:54:42 adam Exp $
+$NetBSD: patch-ab,v 1.4 2009/02/07 17:55:42 adam Exp $
 
---- configure.orig     2008-06-09 02:38:40.000000000 +0200
+--- configure.orig     2009-01-30 03:59:28.000000000 +0100
 +++ configure
 @@ -1510,6 +1510,7 @@ case $host_os in
    darwin*) template=darwin ;;
@@ -18,6 +18,6 @@
 -pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
 -perl_embed_ldflags=`echo X"$pgac_tmp1" | sed "s/^X//;s%$pgac_tmp2%%"`
 +perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
- echo "$as_me:$LINENO: result: $perl_embed_ldflags" >&5
- echo "${ECHO_T}$perl_embed_ldflags" >&6
- fi
+ if test -z "$perl_embed_ldflags" ; then
+       echo "$as_me:$LINENO: result: no" >&5
+ echo "${ECHO_T}no" >&6



Home | Main Index | Thread Index | Old Index