Subject: CVS commit: pkgsrc/databases
To: None <>
From: Johnny C. Lam <>
List: pkgsrc-changes
Date: 08/05/2005 19:43:45
Module Name:	pkgsrc
Committed By:	jlam
Date:		Fri Aug  5 19:43:45 UTC 2005

Modified Files:
	pkgsrc/databases/postgresql80: Makefile Makefile.common distinfo
	pkgsrc/databases/postgresql80-client: Makefile PLIST
	pkgsrc/databases/postgresql80-server: Makefile PLIST
	pkgsrc/databases/postgresql80/files: Makefile.custom
	pkgsrc/databases/postgresql80/patches: patch-aa patch-ab
Added Files:
	pkgsrc/databases/postgresql80: Makefile.mirrors
	pkgsrc/databases/postgresql80/files: Makefile.libtool dynloader-ltdl.h
	pkgsrc/databases/postgresql80/patches: patch-ac patch-ad patch-ae
	    patch-af patch-ag patch-ah patch-ai
Removed Files:
	pkgsrc/databases/postgresql80/files: GNUmakefile.libpgtcl netbsd.c

Log Message:
Several changes to the postgresql80-* packages:

* Become maintainer for the postgresql80-* packages (ok'd by recht)

* Libtoolize postgresql80 build so that the shared libraries and
  loadable shared modules are built using libtool.  This should make
  PostgreSQL 8.0.x in pkgsrc build correctly on more pkgsrc-supported
  platforms.  This is accomplished with the Makefile.libtool file
  which replaces the Makefile.shlib file in the PostgreSQL distribution.

* Add libltdl modifications from the postgresql74-* packages so that
  this can work on Interix (untested).

* Fix some mismatches between static function declarations and their
  subsesquent definitions in the src/timezone module.  Fixes provided
  by Georg Schwarz.

* Convert PGSQL_USE_HIER into the PKG_OPTION "pgsql-hier-query", and
  teach both postgresql80-client and postgresql80-server to use it.

* Use BUILDLINK_TRANSFORM's "rm" action to remove unwanted compiler

* Remove zlib/ from postgresql80-client/
  as zlib is only used by the pg_dump client.

* Convert some files in files/* into patches that can be fed back
  to the PostgreSQL team.

* Install data and documentation files into share/postgresql instead
  of share/postgresql80 -- it's only possible to install one PostgreSQL
  version at a time in pkgsrc, and the new paths more closely match
  the rest of the installation paths.

* Add more mirrors to the MASTER_SITES list, and add a new variable
  POSTGRESQL_MIRRORS_SORT that has the same syntax as MASTER_SORT that
  can help people pick a nearby mirror.

* Nuke references to libpgtcl which is no longer distributed as part
  of a standard PostgreSQL installation as of version 8.0.

* Provide better documentation for Makefile.custom.

* Avoid linking in the pthread library in the correct way on NetBSD
  by setting DLOPEN_REQUIRE_PTHREADS=no.  Also, provide better
  documentation on why we can't enable thread-safety in the PostgreSQL
  libraries on NetBSD (at least for now).

* Preliminary support for installing postgresql80-* into a separate
  subdirectory under ${LOCALBASE} so possibly allow for multiple
  installations of PostgreSQL on the same machine.  Note that THIS

* Update the hierarchical-queries patch to "8.0.3-0.5.5" which fixes
  a bug which was crashing the backend when PRIOR was used in the
  target list.  The _level_ column is no longer automatically added
  to target list.  This makes it possible to use hierarchical queries
  as IN subqueries.  To get _level_ back you just have to explicitly
  mention it in target list.

Bump the following PKGREVISIONs:

	postgresql80-client	-> 2
	postgresql80-server	-> 2
	postgresql80		-> 1

To generate a diff of this commit:
cvs rdiff -r1.4 -r1.5 pkgsrc/databases/postgresql80/Makefile
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/postgresql80/Makefile.common
cvs rdiff -r0 -r1.1 pkgsrc/databases/postgresql80/Makefile.mirrors \
cvs rdiff -r1.6 -r1.7 pkgsrc/databases/postgresql80/distinfo
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/postgresql80-client/Makefile
cvs rdiff -r1.4 -r1.5 pkgsrc/databases/postgresql80-client/PLIST
cvs rdiff -r1.1 -r1.2 pkgsrc/databases/postgresql80-client/
cvs rdiff -r1.8 -r1.9 pkgsrc/databases/postgresql80-server/Makefile
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/postgresql80-server/PLIST
cvs rdiff -r1.3 -r1.4 pkgsrc/databases/postgresql80-server/files/
cvs rdiff -r1.1.1.1 -r0 \
    pkgsrc/databases/postgresql80/files/GNUmakefile.libpgtcl \
    pkgsrc/databases/postgresql80/files/netbsd.c \
cvs rdiff -r1.1.1.1 -r1.2 pkgsrc/databases/postgresql80/files/Makefile.custom
cvs rdiff -r0 -r1.1 pkgsrc/databases/postgresql80/files/Makefile.libtool \
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql80/patches/patch-aa
cvs rdiff -r1.3 -r1.4 pkgsrc/databases/postgresql80/patches/patch-ab
cvs rdiff -r0 -r1.1 pkgsrc/databases/postgresql80/patches/patch-ac \
    pkgsrc/databases/postgresql80/patches/patch-ad \
    pkgsrc/databases/postgresql80/patches/patch-ae \
    pkgsrc/databases/postgresql80/patches/patch-af \
    pkgsrc/databases/postgresql80/patches/patch-ag \
    pkgsrc/databases/postgresql80/patches/patch-ah \

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