Module Name:	pkgsrc
Committed By:	ghen
Date:		Tue Oct 31 10:18:20 UTC 2006

Modified Files:
	pkgsrc/databases/postgresql74 [pkgsrc-2006Q3]: Makefile.common distinfo
	pkgsrc/databases/postgresql74-client [pkgsrc-2006Q3]: Makefile
	pkgsrc/databases/postgresql74-contrib [pkgsrc-2006Q3]: Makefile
	pkgsrc/databases/postgresql74-docs [pkgsrc-2006Q3]: Makefile PLIST
	pkgsrc/databases/postgresql74-lib [pkgsrc-2006Q3]: Makefile
	pkgsrc/databases/postgresql74-server [pkgsrc-2006Q3]: Makefile PLIST
	pkgsrc/databases/postgresql80 [pkgsrc-2006Q3]: Makefile.common distinfo
	    options.mk
	pkgsrc/databases/postgresql80-client [pkgsrc-2006Q3]: Makefile PLIST
	pkgsrc/databases/postgresql80-server [pkgsrc-2006Q3]: Makefile
	pkgsrc/databases/postgresql81 [pkgsrc-2006Q3]: Makefile.common distinfo
	    options.mk
	pkgsrc/databases/postgresql81-client [pkgsrc-2006Q3]: Makefile PLIST
	pkgsrc/databases/postgresql81-server [pkgsrc-2006Q3]: Makefile

Log Message:
Pullup ticket 1879 - requested by joerg
security updates for postgresql

- pkgsrc/databases/postgresql74/Makefile.common		1.37
- pkgsrc/databases/postgresql74/distinfo		1.22
- pkgsrc/databases/postgresql74-client/Makefile		1.21
- pkgsrc/databases/postgresql74-contrib/Makefile	1.14
- pkgsrc/databases/postgresql74-docs/Makefile		1.10-1.11
- pkgsrc/databases/postgresql74-docs/PLIST		1.7-1.8
- pkgsrc/databases/postgresql74-lib/Makefile		1.26
- pkgsrc/databases/postgresql74-server/Makefile		1.27
- pkgsrc/databases/postgresql74-server/PLIST		1.6
- pkgsrc/databases/postgresql80/Makefile.common		1.24
- pkgsrc/databases/postgresql80/distinfo		1.14
- pkgsrc/databases/postgresql80/options.mk		1.4
- pkgsrc/databases/postgresql80-client/Makefile		1.17
- pkgsrc/databases/postgresql80-client/PLIST		1.12
- pkgsrc/databases/postgresql80-server/Makefile		1.22
- pkgsrc/databases/postgresql81/Makefile.common		1.7
- pkgsrc/databases/postgresql81/distinfo		1.3
- pkgsrc/databases/postgresql81/options.mk		1.2
- pkgsrc/databases/postgresql81-client/Makefile		1.4
- pkgsrc/databases/postgresql81-client/PLIST		1.3
- pkgsrc/databases/postgresql81-server/Makefile		1.5

   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:31:24 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81: Makefile.common distinfo options.mk

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:33:21 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81-client: Makefile PLIST

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 16:34:17 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql81-server: Makefile

   Log Message:
   Changes 8.1.5:
   * Disallow aggregate functions in "UPDATE" commands, except within
     sub-SELECTs (Tom)
     The behavior of such an aggregate was unpredictable, and in 8.1.X
     could cause a crash, so it has been disabled. The SQL standard does
     not allow this either.
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix core dump in duration logging for extended query protocol when
     a "COMMIT" or "ROLLBACK" is executed
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix to_timestamp() for AM/PM formats (Bruce)
   * Fix autovacuum's calculation that decides whether "ANALYZE" is
     needed (Alvaro)
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Minor fixes in /contrib/dblink and /contrib/tsearch2
   * Efficiency improvements in hash tables and bitmap index scans (Tom)
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fix statement_timeout to use the proper units on Win32 (Bruce)
     In previous Win32 8.1.X versions, the delay was off by a factor of
     100.
   * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:38:57 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql80: Makefile.common distinfo options.mk

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:39:09 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql80-client: Makefile PLIST

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 18:39:19 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql80-server: Makefile

   Log Message:
   Changes 8.0.9:
   * Fix crash when referencing NEW row values in rule WHERE expressions
     (Tom)
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix mishandling of AFTER triggers when query contains a SQL
     function returning multiple rows (Tom)
   * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
     (Tom)
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Numerous robustness fixes in ecpg (Joachim Wieland)
   * Fix backslash escaping in /contrib/dbmirror
   * Fix instability of statistics collection on Win32 (Tom, Andrew)
   * Fixes for AIX and Intel compilers (Tom)
---
   Module Name:	pkgsrc
   Committed By:	adam
   Date:		Wed Oct 18 19:24:07 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql74: Makefile.common distinfo
	pkgsrc/databases/postgresql74-client: Makefile
	pkgsrc/databases/postgresql74-contrib: Makefile
	pkgsrc/databases/postgresql74-docs: Makefile PLIST
	pkgsrc/databases/postgresql74-lib: Makefile
	pkgsrc/databases/postgresql74-server: Makefile PLIST

   Log Message:
   Changes 7.4.14:
   * Fix core dump when an untyped literal is taken as ANYARRAY
   * Fix string_to_array() to handle overlapping matches for the
     separator string
     For example, string_to_array('123xx456xxx789', 'xx').
   * Fix corner cases in pattern matching for psql's \d commands
   * Fix index-corrupting bugs in /contrib/ltree (Teodor)
   * Fix backslash escaping in /contrib/dbmirror
   * Adjust regression tests for recent changes in US DST laws
---
   Module Name:	pkgsrc
   Committed By:	ghen
   Date:		Tue Oct 31 10:12:00 UTC 2006

   Modified Files:
	pkgsrc/databases/postgresql74-docs: Makefile PLIST

   Log Message:
   Fix PLIST, bump PKGREVISION.


To generate a diff of this commit:
cvs rdiff -r1.36 -r1.36.4.1 pkgsrc/databases/postgresql74/Makefile.common
cvs rdiff -r1.21 -r1.21.4.1 pkgsrc/databases/postgresql74/distinfo
cvs rdiff -r1.20 -r1.20.6.1 pkgsrc/databases/postgresql74-client/Makefile
cvs rdiff -r1.13 -r1.13.6.1 pkgsrc/databases/postgresql74-contrib/Makefile
cvs rdiff -r1.9 -r1.9.6.1 pkgsrc/databases/postgresql74-docs/Makefile
cvs rdiff -r1.6 -r1.6.4.1 pkgsrc/databases/postgresql74-docs/PLIST
cvs rdiff -r1.25 -r1.25.2.1 pkgsrc/databases/postgresql74-lib/Makefile
cvs rdiff -r1.26 -r1.26.4.1 pkgsrc/databases/postgresql74-server/Makefile
cvs rdiff -r1.5 -r1.5.4.1 pkgsrc/databases/postgresql74-server/PLIST
cvs rdiff -r1.23 -r1.23.4.1 pkgsrc/databases/postgresql80/Makefile.common
cvs rdiff -r1.13 -r1.13.4.1 pkgsrc/databases/postgresql80/distinfo
cvs rdiff -r1.3 -r1.3.8.1 pkgsrc/databases/postgresql80/options.mk
cvs rdiff -r1.16 -r1.16.6.1 pkgsrc/databases/postgresql80-client/Makefile
cvs rdiff -r1.11 -r1.11.4.1 pkgsrc/databases/postgresql80-client/PLIST
cvs rdiff -r1.21 -r1.21.4.1 pkgsrc/databases/postgresql80-server/Makefile
cvs rdiff -r1.6 -r1.6.4.1 pkgsrc/databases/postgresql81/Makefile.common
cvs rdiff -r1.2 -r1.2.4.1 pkgsrc/databases/postgresql81/distinfo
cvs rdiff -r1.1.1.1 -r1.1.1.1.6.1 pkgsrc/databases/postgresql81/options.mk
cvs rdiff -r1.3 -r1.3.6.1 pkgsrc/databases/postgresql81-client/Makefile
cvs rdiff -r1.2 -r1.2.4.1 pkgsrc/databases/postgresql81-client/PLIST
cvs rdiff -r1.4 -r1.4.4.1 pkgsrc/databases/postgresql81-server/Makefile

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