The NetBSD Project

CVS log for pkgsrc/databases/postgresql80/Attic/Makefile.common

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql80

Request diff between arbitrary revisions


Default branch: MAIN


Revision 1.32, Thu Mar 13 17:45:02 2008 UTC (14 years, 10 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2013Q2-base, pkgsrc-2013Q2, pkgsrc-2012Q4-base, pkgsrc-2012Q4, pkgsrc-2011Q4-base, pkgsrc-2011Q4, pkgsrc-2011Q2-base, pkgsrc-2011Q2, pkgsrc-2009Q4-base, pkgsrc-2009Q4, pkgsrc-2008Q4-base, pkgsrc-2008Q4, pkgsrc-2008Q3-base, pkgsrc-2008Q3, pkgsrc-2008Q2-base, pkgsrc-2008Q2, pkgsrc-2008Q1-base, pkgsrc-2008Q1, cube-native-xorg-base, cube-native-xorg, HEAD
Changes since 1.31: +1 -1 lines
FILE REMOVED

Remove PostgreSQL 8.0.

Revision 1.30.4.1 / (download) - annotate - [select for diffs], Thu Jan 10 07:33:53 2008 UTC (15 years ago) by ghen
Branch: pkgsrc-2007Q4
Changes since 1.30: +2 -2 lines
Diff to previous 1.30 (colored) next main 1.31 (colored)

Pullup ticket 2259 - requested by adam
security updates for postgresql

- pkgsrc/databases/postgresql80/Makefile.common		1.31
- pkgsrc/databases/postgresql80/distinfo		1.20
- pkgsrc/databases/postgresql80-client/PLIST		1.18
- pkgsrc/databases/postgresql80-server/PLIST		1.11
- pkgsrc/databases/postgresql81/Makefile.common		1.15
- pkgsrc/databases/postgresql81/distinfo		1.11
- pkgsrc/databases/postgresql81-client/PLIST		1.9
- pkgsrc/databases/postgresql81-server/PLIST		1.5
- pkgsrc/databases/postgresql82/Makefile.common		1.8
- pkgsrc/databases/postgresql82/distinfo		1.10
- pkgsrc/databases/postgresql82/patches/patch-am	1.3
- pkgsrc/databases/postgresql82-client/PLIST		1.7
- pkgsrc/databases/postgresql82-server/PLIST		1.5
- pkgsrc/databases/postgresql82-tsearch2/Makefile	1.3

   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Jan  7 20:14:10 UTC 2008

   Modified Files:
	   pkgsrc/databases/postgresql80: Makefile.common distinfo
	   pkgsrc/databases/postgresql80-client: PLIST
	   pkgsrc/databases/postgresql80-server: PLIST

   Log Message:
   Changes 8.0.15:
   This release contains a variety of fixes from 8.0.14, including fixes
   for significant security issues.

   This is the last 8.0.X release for which the PostgreSQL community will
   produce binary packages for Windows. Windows users are encouraged to
   move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X
   that are impractical to back-port. 8.0.X will continue to be supported
   on other platforms.
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Jan  7 20:14:24 UTC 2008

   Modified Files:
	   pkgsrc/databases/postgresql81: Makefile.common distinfo
	   pkgsrc/databases/postgresql81-client: PLIST
	   pkgsrc/databases/postgresql81-server: PLIST

   Log Message:
   Changes 8.1.11:
   This release contains a variety of fixes from 8.1.10, including fixes
   for significant security issues.

   This is the last 8.1.X release for which the PostgreSQL community will
   produce binary packages for Windows. Windows users are encouraged to
   move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X
   that are impractical to back-port. 8.1.X will continue to be supported
   on other platforms.
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Jan  7 20:14:36 UTC 2008

   Modified Files:
	   pkgsrc/databases/postgresql82: Makefile.common distinfo
	   pkgsrc/databases/postgresql82-client: PLIST
	   pkgsrc/databases/postgresql82-server: PLIST
	   pkgsrc/databases/postgresql82-tsearch2: Makefile
	   pkgsrc/databases/postgresql82/patches: patch-am

   Log Message:
   Changes 8.2.6:
   This release contains a variety of fixes from 8.2.5, including fixes
   for significant security issues.

Revision 1.31 / (download) - annotate - [select for diffs], Mon Jan 7 20:14:09 2008 UTC (15 years, 1 month ago) by adam
Branch: MAIN
Changes since 1.30: +2 -2 lines
Diff to previous 1.30 (colored)

Changes 8.0.15:
This release contains a variety of fixes from 8.0.14, including fixes
for significant security issues.

This is the last 8.0.X release for which the PostgreSQL community will
produce binary packages for Windows. Windows users are encouraged to
move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X
that are impractical to back-port. 8.0.X will continue to be supported
on other platforms.

Revision 1.30 / (download) - annotate - [select for diffs], Wed Sep 19 20:01:47 2007 UTC (15 years, 4 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2007Q4-base, pkgsrc-2007Q3-base, pkgsrc-2007Q3
Branch point for: pkgsrc-2007Q4
Changes since 1.29: +2 -2 lines
Diff to previous 1.29 (colored)

Changes 8.0.14:
* Prevent index corruption when a transaction inserts rows and then
  aborts close to the end of a concurrent "VACUUM" on the same table
* Make "CREATE DOMAIN ... DEFAULT NULL" work properly
* Fix excessive logging of SSL error messages
* Fix logging so that log messages are never interleaved when using
  the syslogger process
* Fix crash when log_min_error_statement logging runs out of memory
* Fix incorrect handling of some foreign-key corner cases
* Prevent "CLUSTER" from failing due to attempting to process
  temporary tables of other sessions
* Update the time zone database rules, particularly New Zealand's
  upcoming changes
* Windows socket improvements
* Suppress timezone name (%Z) in log timestamps on Windows because of
  possible encoding mismatches
* Require non-superusers who use "/contrib/dblink" to use only
  password authentication, as a security measure

Revision 1.27.2.1 / (download) - annotate - [select for diffs], Sat May 12 14:39:50 2007 UTC (15 years, 8 months ago) by salo
Branch: pkgsrc-2007Q1
Changes since 1.27: +7 -3 lines
Diff to previous 1.27 (colored) next main 1.28 (colored)

Pullup ticket 2080 - requested by ghen
security update for postgresql

Revisions pulled up:
- pkgsrc/databases/postgresql80/Makefile.common		1.28, 1.29
- pkgsrc/databases/postgresql80/distinfo		1.18
- pkgsrc/databases/postgresql80-client/PLIST		1.16
- pkgsrc/databases/postgresql80-server/Makefile		1.24
- pkgsrc/databases/postgresql80-server/PLIST		1.9
- pkgsrc/databases/postgresql81/Makefile.common		1.11, 1.12, 1.13
- pkgsrc/databases/postgresql81/distinfo		1.9
- pkgsrc/databases/postgresql81-client/PLIST		1.7
- pkgsrc/databases/postgresql81-server/PLIST		1.3
- pkgsrc/databases/postgresql82/Makefile.common		1.5, 1.6
- pkgsrc/databases/postgresql82/distinfo		1.7
- pkgsrc/databases/postgresql82-client/PLIST		1.5
- pkgsrc/databases/postgresql82-server/PLIST		1.3

   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Apr 30 13:37:01 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql82: Makefile.common distinfo
   	pkgsrc/databases/postgresql82-client: PLIST
   	pkgsrc/databases/postgresql82-server: PLIST

   Log Message:
   Changes 8.2.4:
   * Support explicit placement of the temporary-table schema within
     search_path, and disable searching it for functions and operators
   * Fix shared_preload_libraries for Windows by forcing reload in each
     backend
   * Fix to_char() so it properly upper/lower cases localized day or
     month names
   * "/contrib/tsearch2" crash fixes
   * Require "COMMIT PREPARED" to be executed in the same database as
     the transaction was prepared in
   * Allow "pg_dump" to do binary backups larger than two gigabytes on
     Windows
   * New traditional (Taiwan) Chinese FAQ
   * Prevent the statistics collector from writing to disk too
     frequently
   * Fix potential-data-corruption bug in how "VACUUM FULL" handles
     "UPDATE" chains
   * Fix bug in domains that use array types
   * Fix "pg_dump" so it can dump a serial column's sequence using "-t"
     when not also dumping the owning table
   * Planner fixes, including improving outer join and bitmap scan
     selection logic
   * Fix possible wrong answers or crash when a PL/pgSQL function tries
     to RETURN from within an EXCEPTION block
   * Fix PANIC during enlargement of a hash index
   * Fix POSIX-style timezone specs to follow new USA DST rules
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Apr 30 13:37:23 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql81: Makefile.common distinfo
   	pkgsrc/databases/postgresql81-client: PLIST
   	pkgsrc/databases/postgresql81-server: PLIST

   Log Message:
   Changes 8.1.9:
   * Support explicit placement of the temporary-table schema within
     search_path, and disable searching it for functions and operators
   * "/contrib/tsearch2" crash fixes
   * Require "COMMIT PREPARED" to be executed in the same database as
     the transaction was prepared in
   * Fix potential-data-corruption bug in how "VACUUM FULL" handles
     "UPDATE" chains
   * Planner fixes, including improving outer join and bitmap scan
     selection logic
   * Fix PANIC during enlargement of a hash index (bug introduced in
     8.1.6)
   * Fix POSIX-style timezone specs to follow new USA DST rules
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Mon Apr 30 13:37:36 UTC 2007

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

   Log Message:
   Changes 8.0.13:
   * Support explicit placement of the temporary-table schema within
     search_path, and disable searching it for functions and operators
   * "/contrib/tsearch2" crash fixes
   * Fix potential-data-corruption bug in how "VACUUM FULL" handles
     "UPDATE" chains
   * Fix PANIC during enlargement of a hash index (bug introduced in
     8.0.10)
   * Fix POSIX-style timezone specs to follow new USA DST rules
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Fri May  4 19:44:52 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql81: Makefile.common

   Log Message:
   CONFLICTS fix
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Fri May  4 19:45:52 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql82: Makefile.common

   Log Message:
   CONFLICTS fix
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Fri May  4 20:04:06 UTC 2007

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

   Log Message:
   CONFLICTS and PLIST fix
---
   Module Name:		pkgsrc
   Committed By:	adam
   Date:		Fri May  4 20:04:52 UTC 2007

   Modified Files:
   	pkgsrc/databases/postgresql81: Makefile.common

   Log Message:
   CONFLICTS fix
---
   Module Name:		pkgsrc
   Committed By:	joerg
   Date:		Tue May  8 15:58:39 UTC 2007

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

   Log Message:
   Fix PLIST after last update.

Revision 1.29 / (download) - annotate - [select for diffs], Fri May 4 20:04:06 2007 UTC (15 years, 9 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2007Q2-base, pkgsrc-2007Q2
Changes since 1.28: +5 -5 lines
Diff to previous 1.28 (colored)

CONFLICTS and PLIST fix

Revision 1.28 / (download) - annotate - [select for diffs], Mon Apr 30 13:37:36 2007 UTC (15 years, 9 months ago) by adam
Branch: MAIN
Changes since 1.27: +7 -3 lines
Diff to previous 1.27 (colored)

Changes 8.0.13:
* Support explicit placement of the temporary-table schema within
  search_path, and disable searching it for functions and operators
* "/contrib/tsearch2" crash fixes
* Fix potential-data-corruption bug in how "VACUUM FULL" handles
  "UPDATE" chains
* Fix PANIC during enlargement of a hash index (bug introduced in
  8.0.10)
* Fix POSIX-style timezone specs to follow new USA DST rules

Revision 1.27 / (download) - annotate - [select for diffs], Thu Feb 8 20:00:57 2007 UTC (15 years, 11 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2007Q1-base
Branch point for: pkgsrc-2007Q1
Changes since 1.26: +2 -2 lines
Diff to previous 1.26 (colored)

Changes 8.0.12:
* Remove overly-restrictive check for type length in constraints and
  functional indexes

Revision 1.26 / (download) - annotate - [select for diffs], Mon Feb 5 11:58:42 2007 UTC (16 years ago) by adam
Branch: MAIN
Changes since 1.25: +2 -2 lines
Diff to previous 1.25 (colored)

Changes 8.0.11:
* Remove security vulnerabilities that allowed connected users to
  read backend memory
* Fix rare bug wherein btree index page splits could fail due to
  choosing an infeasible split point
* Fix for rare Assert() crash triggered by UNION
* Tighten security of multi-byte character processing for UTF8
  sequences over three bytes long

Revision 1.25 / (download) - annotate - [select for diffs], Mon Jan 8 20:30:42 2007 UTC (16 years ago) by adam
Branch: MAIN
Changes since 1.24: +2 -2 lines
Diff to previous 1.24 (colored)

Changes 8.0.10:
* Improve handling of getaddrinfo() on AIX
  This fixes a problem with starting the statistics collector, among
  other things.
* Fix "failed to re-find parent key" errors in "VACUUM"
* Fix race condition for truncation of a large relation across a
  gigabyte boundary by "VACUUM"
* Fix bugs affecting multi-gigabyte hash indexes
* Fix possible deadlock in Windows signal handling
* Fix error when constructing an ARRAY[] made up of multiple empty
  elements
* Fix ecpg memory leak during connection
* to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for
  new initdb installs
  This is because lc_numeric can potentially change the output of
  these functions.
* Improve index usage of regular expressions that use parentheses
  This improves psql \d performance also.
* Update timezone database
  This affects Australian and Canadian daylight-savings rules in
  particular.

Revision 1.23.4.1 / (download) - annotate - [select for diffs], Tue Oct 31 10:18:20 2006 UTC (16 years, 3 months ago) by ghen
Branch: pkgsrc-2006Q3
Changes since 1.23: +19 -19 lines
Diff to previous 1.23 (colored) next main 1.24 (colored)

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.

Revision 1.24 / (download) - annotate - [select for diffs], Wed Oct 18 18:38:57 2006 UTC (16 years, 3 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2006Q4-base, pkgsrc-2006Q4
Changes since 1.23: +19 -19 lines
Diff to previous 1.23 (colored)

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)

Revision 1.19.2.1 / (download) - annotate - [select for diffs], Wed May 31 11:53:44 2006 UTC (16 years, 8 months ago) by salo
Branch: pkgsrc-2006Q1
Changes since 1.19: +2 -2 lines
Diff to previous 1.19 (colored) next main 1.20 (colored)

Pullup ticket 1680 - requested by joerg
security updates for postgresql

Revisions pulled up:
- pkgsrc/databases/postgresql73/Makefile.common		1.19
- pkgsrc/databases/postgresql73/distinfo		1.13
- pkgsrc/databases/postgresql73-docs/PLIST		1.7
- pkgsrc/databases/postgresql74/Makefile.common		1.36
- pkgsrc/databases/postgresql74/distinfo		1.21
- pkgsrc/databases/postgresql74-docs/PLIST		1.6
- pkgsrc/databases/postgresql80/Makefile.common		1.23
- pkgsrc/databases/postgresql80/distinfo		1.13
- pkgsrc/databases/postgresql80-client/PLIST		1.11
- pkgsrc/databases/postgresql81/Makefile.common		1.6
- pkgsrc/databases/postgresql81/distinfo		1.2
- pkgsrc/databases/postgresql81-client/PLIST		1.2

   Module Name:	pkgsrc
   Committed By:	joerg
   Date:		Fri May 26 17:47:58 UTC 2006

   Modified Files:
   	pkgsrc/databases/postgresql73: Makefile.common distinfo
   	pkgsrc/databases/postgresql73-docs: PLIST
   	pkgsrc/databases/postgresql74: Makefile.common distinfo
   	pkgsrc/databases/postgresql74-docs: PLIST
   	pkgsrc/databases/postgresql80: Makefile.common distinfo
   	pkgsrc/databases/postgresql80-client: PLIST
   	pkgsrc/databases/postgresql81: Makefile.common distinfo
   	pkgsrc/databases/postgresql81-client: PLIST

   Log Message:
   Update PostgreSQL to 7.3.15, 7.4.13, 8.0.8 and 8.1.4 respectively.

   Common to all versions:
        * Change the server to reject invalidly-encoded multibyte characters
          in all cases (Tatsuo, Tom) While PostgreSQL has been moving in this
          direction for some time, the checks are now applied uniformly to
          all encodings and all textual input, and are now always errors not
          merely warnings. This change defends against SQL-injection attacks
          of the type described in CVE-2006-2313.
        * Reject unsafe uses of \' in string literals As a server-side
          defense against SQL-injection attacks of the type described in
          CVE-2006-2314, the server now only accepts '' and not \' as a
          representation of ASCII single quote in SQL string literals. By
          default, \' is  rejected  only  when  client_encoding is set to a
          client-only encoding (SJIS, BIG5, GBK, GB18030, or UHC), which is
          the scenario in which SQL injection is possible. A new
          configuration parameter backslash_quote is available  to  adjust
          this  behavior  when needed. Note that full security against
          CVE-2006-2314 may require client-side changes; the purpose of
          backslash_quote is in part to make it obvious that insecure clients
          are insecure.
        * Modify libpq's string-escaping routines to be aware of encoding
          considerations This  fixes  libpq-using applications for the
          security issues described in CVE-2006-2313 and CVE-2006-2314.
          Applications that use multiple PostgreSQL connections concurrently
          should migrate to PQescapeStringConn() and PQescapeByteaConn() to
          ensure that escaping is done correctly for the settings in use in
          each database connection. Applications that do string escaping
          "by hand" should be modified to rely on library routines instead.
        * Fix some incorrect encoding conversion functions win1251_to_iso,
          alt_to_iso, euc_tw_to_big5, euc_tw_to_mic, mic_to_euc_tw were all
          broken to varying extents.
        * Clean up stray remaining uses of \' in strings (Bruce, Jan)
        * Fix server to use custom DH SSL parameters correctly (Michael Fuhr)
        * Fix various minor memory leaks

   Additionally for 7.4.13 and later:
        * Fix bug that sometimes caused OR'd index scans to miss rows they
          should have returned
        * Fix WAL replay for case where a btree index has been truncated
        * Fix SIMILAR TO for patterns involving | (Tom)
        * Fix for Bonjour on Intel Macs (Ashley Clark)

   Additionally for 8.0.8 and 8.1.4:
        * Fix SELECT INTO and CREATE TABLE AS to create tables in the
          default tablespace, not the base directory (Kris Jurka)
        * Fix problem with password prompting on some Win32 systems (Robert
          Kinberg)

   Additionally for 8.1.4:
        * Fix weak key selection in pgcrypto (Marko Kreen)
          Errors in fortuna PRNG reseeding logic could cause a predictable
          session key to be selected by pgp_sym_encrypt() in some cases.
          This only affects non-OpenSSL-using builds.
        * Make autovacuum visible in pg_stat_activity (Alvaro)
        * Disable full_page_writes (Tom)
          In certain cases, having full_page_writes off would cause crash
          recovery to fail. A proper fix will appear in 8.2; for now it's
          just disabled.
        * Various planner fixes, particularly for bitmap index scans and
          MIN/MAX optimization (Tom)
        * Fix incorrect optimization in merge join (Tom)
          Outer joins could sometimes emit multiple copies of unmatched
          rows.
        * Fix crash from using and modifying a plpgsql function in the same
          transaction
        * Improve qsort performance (Dann Corbit)
          Currently this code is only used on Solaris.
        * Improve pg_dump's handling of default values for domains
        * Fix pg_dumpall to handle identically-named users and groups
          reasonably (only possible when dumping from a pre-8.1 server) (Tom)
          The user and group will be merged into a single role with LOGIN
          permission. Formerly the merged role wouldn't have LOGIN
          permission, making it unusable as a user.
        * Fix pg_restore -n to work as documented (Tom)

Revision 1.23 / (download) - annotate - [select for diffs], Fri May 26 17:47:58 2006 UTC (16 years, 8 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2006Q3-base, pkgsrc-2006Q2-base, pkgsrc-2006Q2
Branch point for: pkgsrc-2006Q3
Changes since 1.22: +2 -2 lines
Diff to previous 1.22 (colored)

Update PostgreSQL to 7.3.15, 7.4.13, 8.0.8 and 8.1.4 respectively.

Common to all versions:
     * Change the server to reject invalidly-encoded multibyte characters
       in all cases (Tatsuo, Tom) While PostgreSQL has been moving in this
       direction for some time, the checks are now applied uniformly to
       all encodings and all textual input, and are now always errors not
       merely warnings. This change defends against SQL-injection attacks
       of the type described in CVE-2006-2313.
     * Reject unsafe uses of \' in string literals As a server-side
       defense against SQL-injection attacks of the type described in
       CVE-2006-2314, the server now only accepts '' and not \' as a
       representation of ASCII single quote in SQL string literals. By
       default, \' is  rejected  only  when  client_encoding is set to a
       client-only encoding (SJIS, BIG5, GBK, GB18030, or UHC), which is
       the scenario in which SQL injection is possible. A new
       configuration parameter backslash_quote is available  to  adjust
       this  behavior  when needed. Note that full security against
       CVE-2006-2314 may require client-side changes; the purpose of
       backslash_quote is in part to make it obvious that insecure clients
       are insecure.
     * Modify libpq's string-escaping routines to be aware of encoding
       considerations This  fixes  libpq-using applications for the
       security issues described in CVE-2006-2313 and CVE-2006-2314.
       Applications that use multiple PostgreSQL connections concurrently
       should migrate to PQescapeStringConn() and PQescapeByteaConn() to
       ensure that escaping is done correctly for the settings in use in
       each database connection. Applications that do string escaping
       "by hand" should be modified to rely on library routines instead.
     * Fix some incorrect encoding conversion functions win1251_to_iso,
       alt_to_iso, euc_tw_to_big5, euc_tw_to_mic, mic_to_euc_tw were all
       broken to varying extents.
     * Clean up stray remaining uses of \' in strings (Bruce, Jan)
     * Fix server to use custom DH SSL parameters correctly (Michael Fuhr)
     * Fix various minor memory leaks

Additionally for 7.4.13 and later:
     * Fix bug that sometimes caused OR'd index scans to miss rows they
       should have returned
     * Fix WAL replay for case where a btree index has been truncated
     * Fix SIMILAR TO for patterns involving | (Tom)
     * Fix for Bonjour on Intel Macs (Ashley Clark)

Additionally for 8.0.8 and 8.1.4:
     * Fix SELECT INTO and CREATE TABLE AS to create tables in the
       default tablespace, not the base directory (Kris Jurka)
     * Fix problem with password prompting on some Win32 systems (Robert
       Kinberg)

Additionally for 8.1.4:
     * Fix weak key selection in pgcrypto (Marko Kreen)
       Errors in fortuna PRNG reseeding logic could cause a predictable
       session key to be selected by pgp_sym_encrypt() in some cases.
       This only affects non-OpenSSL-using builds.
     * Make autovacuum visible in pg_stat_activity (Alvaro)
     * Disable full_page_writes (Tom)
       In certain cases, having full_page_writes off would cause crash
       recovery to fail. A proper fix will appear in 8.2; for now it's
       just disabled.
     * Various planner fixes, particularly for bitmap index scans and
       MIN/MAX optimization (Tom)
     * Fix incorrect optimization in merge join (Tom)
       Outer joins could sometimes emit multiple copies of unmatched
       rows.
     * Fix crash from using and modifying a plpgsql function in the same
       transaction
     * Improve qsort performance (Dann Corbit)
       Currently this code is only used on Solaris.
     * Improve pg_dump's handling of default values for domains
     * Fix pg_dumpall to handle identically-named users and groups
       reasonably (only possible when dumping from a pre-8.1 server) (Tom)
       The user and group will be merged into a single role with LOGIN
       permission. Formerly the merged role wouldn't have LOGIN
       permission, making it unusable as a user.
     * Fix pg_restore -n to work as documented (Tom)

Revision 1.22 / (download) - annotate - [select for diffs], Thu Apr 13 18:23:30 2006 UTC (16 years, 9 months ago) by jlam
Branch: MAIN
Changes since 1.21: +2 -3 lines
Diff to previous 1.21 (colored)

BUILD_USE_MSGFMT and USE_MSGFMT_PLURALS are obsolete.  Replace with
USE_TOOLS+=msgfmt.

Revision 1.21 / (download) - annotate - [select for diffs], Sat Apr 8 19:08:25 2006 UTC (16 years, 10 months ago) by jdolecek
Branch: MAIN
Changes since 1.20: +7 -4 lines
Diff to previous 1.20 (colored)

use MASTER_SITE_PGSQL and replace PGSQL_MIRRORS_SORT with MASTER_SORT

Revision 1.20 / (download) - annotate - [select for diffs], Thu Apr 6 06:21:42 2006 UTC (16 years, 10 months ago) by reed
Branch: MAIN
Changes since 1.19: +2 -2 lines
Diff to previous 1.19 (colored)

Over 1200 files touched but no revisions bumped :)

RECOMMENDED is removed. It becomes ABI_DEPENDS.

BUILDLINK_RECOMMENDED.foo becomes BUILDLINK_ABI_DEPENDS.foo.

BUILDLINK_DEPENDS.foo becomes BUILDLINK_API_DEPENDS.foo.

BUILDLINK_DEPENDS does not change.

IGNORE_RECOMMENDED (which defaulted to "no") becomes USE_ABI_DEPENDS
which defaults to "yes".

Added to obsolete.mk checking for IGNORE_RECOMMENDED.

I did not manually go through and fix any aesthetic tab/spacing issues.

I have tested the above patch on DragonFly building and packaging
subversion and pkglint and their many dependencies.

I have also tested USE_ABI_DEPENDS=no on my NetBSD workstation (where I
have used IGNORE_RECOMMENDED for a long time). I have been an active user
of IGNORE_RECOMMENDED since it was available.

As suggested, I removed the documentation sentences suggesting bumping for
"security" issues.

As discussed on tech-pkg.

I will commit to revbump, pkglint, pkg_install, createbuildlink separately.

Note that if you use wip, it will fail!  I will commit to pkgsrc-wip
later (within day).

Revision 1.19 / (download) - annotate - [select for diffs], Tue Mar 14 16:23:46 2006 UTC (16 years, 10 months ago) by joerg
Branch: MAIN
CVS Tags: pkgsrc-2006Q1-base
Branch point for: pkgsrc-2006Q1
Changes since 1.18: +2 -2 lines
Diff to previous 1.18 (colored)

Take maintainership.

Revision 1.18 / (download) - annotate - [select for diffs], Tue Mar 14 16:00:40 2006 UTC (16 years, 10 months ago) by jlam
Branch: MAIN
Changes since 1.17: +2 -2 lines
Diff to previous 1.17 (colored)

Drop maintainership for packages that I no longer have time to maintain.

Revision 1.17 / (download) - annotate - [select for diffs], Wed Mar 8 02:29:06 2006 UTC (16 years, 11 months ago) by grant
Branch: MAIN
Changes since 1.16: +5 -1 lines
Diff to previous 1.16 (colored)

postgresql configure doesn't always correctly detect that it needs
libintl, so pass it via LIBS to configure.

fixes build on Solaris.

Revision 1.12.2.1 / (download) - annotate - [select for diffs], Thu Mar 2 00:30:16 2006 UTC (16 years, 11 months ago) by seb
Branch: pkgsrc-2005Q4
Changes since 1.12: +21 -4 lines
Diff to previous 1.12 (colored) next main 1.13 (colored)

Pullup ticket 1165 - requested by Joerg Sonnenberger
mostly sync databases/postgresql80{,-client,-plperl,-plpython,-pltcl,-server} with HEAD, via patch, including security fix.

Revision 1.16 / (download) - annotate - [select for diffs], Tue Feb 21 19:05:07 2006 UTC (16 years, 11 months ago) by joerg
Branch: MAIN
Changes since 1.15: +2 -2 lines
Diff to previous 1.15 (colored)

Update PostgreSQL 8.0.x to 8.0.7.

The fix for locales and plperl in 8.0.6 might make an REINDEX necessary.

Changes from 8.0.5 to 8.0.6:
- Fix Windows code so that postmaster will continue rather than exit if
there is no more room in ShmemBackendArray (Magnus)
- Fix bug introduced in 8.0 that could allow ReadBuffer to return an
already-used page as new, potentially causing loss of recently-committed
data (Tom)
- Fix for protocol-level Describe messages issued outside a transaction
or in a failed transaction (Tom)
- Fix character string comparison for locales that consider different
character combinations as equal, such as Hungarian (Tom)
- Set locale environment variables during postmaster startup to ensure
that plperl won't change the locale later
- Allow more flexible relocation of installation directories (Tom)
- Fix longstanding bug in strpos() and regular expression handling in
certain rarely used Asian multi-byte character sets (Tatsuo)
- Various fixes for functions returning RECORDs (Tom)
- Fix bug in /contrib/pgcrypto gen_salt, which caused it not to use all
available salt space for MD5 and XDES algorithms (Marko Kreen, Solar
Designer)
- Fix /contrib/dblink to throw an error, rather than crashing, when the
number of columns specified is different from what's actually returned
by the query (Joe)

Changes from 8.0.6 to 8.0.7:
- Fix potential crash in SET SESSION AUTHORIZATION (CVE-2006-0553)
- Fix bug with row visibility logic in self-inserted rows (Tom)
- Fix race condition that could lead to "file already exists" errors
during pg_clog and pg_subtrans file creation (Tom)
- Fix cases that could lead to crashes if a cache-invalidation message
arrives at just the wrong time (Tom)
- Properly check DOMAIN constraints for UNKNOWN parameters in prepared
statements (Neil)
- Ensure ALTER COLUMN TYPE will process FOREIGN KEY, UNIQUE, and PRIMARY
KEY constraints in the proper order (Nakano Yoshihisa)
- Fixes to allow restoring dumps that have cross-schema references to
custom operators or operator classes (Tom)
- Allow pg_restore to continue properly after a COPY failure; formerly
it tried to treat the remaining COPY data as SQL commands (Stephen
Frost)
- Fix pg_ctl unregister crash when the data directory is not specified
(Magnus)
- Fix ecpg crash on AMD64 and PPC (Neil)
- Recover properly if error occurs during argument passing in PL/python
(Neil)
- Fix PL/perl's handling of locales on Win32 to match the backend
(Andrew)
- Fix crash when log_min_messages is set to DEBUG3 or above in
postgresql.conf on Win32 (Bruce)
- Fix pgxs -L library path specification for Win32, Cygwin, OS X, AIX
(Bruce)
- Check that SID is enabled while checking for Win32 admin privileges
(Magnus)
- Properly reject out-of-range date inputs (Kris Jurka)
- Portability fix for testing presence of finite and isinf during
configure (Tom)

Revision 1.15 / (download) - annotate - [select for diffs], Tue Jan 17 08:11:19 2006 UTC (17 years ago) by cjs
Branch: MAIN
Changes since 1.14: +2 -2 lines
Diff to previous 1.14 (colored)

Revert typo: this version conflicts with postgresql74,
not the (non-existent) postgresql84.

Revision 1.14 / (download) - annotate - [select for diffs], Sun Jan 8 12:51:45 2006 UTC (17 years ago) by abs
Branch: MAIN
Changes since 1.13: +4 -4 lines
Diff to previous 1.13 (colored)

Upgrade postgresql80-client, postgresql80-server, postgresql to 8.0.5

Changes since 8.0.4:

    * Fix race condition in transaction log management
      There was a narrow window in which an I/O operation could be
      initiated for the wrong page, leading to an Assert failure
      or data corruption.
    * Fix bgwriter problems after recovering from errors (Tom)
      The background writer was found to leak buffer pins after
      write errors. While not fatal in itself, this might lead to
      mysterious blockages of later VACUUM commands.
    * Prevent failure if client sends Bind protocol message when
      current transaction is already aborted
    * /contrib/ltree fixes (Teodor)
    * AIX and HPUX compile fixes (Tom)
    * Retry file reads and writes after Windows NO_SYSTEM_RESOURCES
      error (Qingqing Zhou)
    * Fix intermittent failure when log_line_prefix includes %i
    * Fix psql performance issue with long scripts on Windows
    (Merlin Moncure)
    * Fix missing updates of pg_group flat file
    * Fix longstanding planning error for outer joins

      This bug sometimes caused a bogus error "RIGHT JOIN is only
      supported with merge-joinable join conditions".
    * Postpone timezone initialization until after postmaster.pid
    is created

      This avoids confusing startup scripts that expect the pid
      file to appear quickly.
    * Prevent core dump in pg_autovacuum when a table has been dropped
    * Fix problems with whole-row references (foo.*) to subquery results

Revision 1.13 / (download) - annotate - [select for diffs], Thu Dec 29 13:33:42 2005 UTC (17 years, 1 month ago) by joerg
Branch: MAIN
Changes since 1.12: +18 -1 lines
Diff to previous 1.12 (colored)

Move DragonFly file handling into Makefile.common, like the other
postgresql packages do. Fixes -pl* at the same time.

Revision 1.12 / (download) - annotate - [select for diffs], Sat Dec 17 05:20:21 2005 UTC (17 years, 1 month ago) by jlam
Branch: MAIN
CVS Tags: pkgsrc-2005Q4-base
Branch point for: pkgsrc-2005Q4
Changes since 1.11: +2 -2 lines
Diff to previous 1.11 (colored)

Change my MAINTAINER email address to the one I've been using for
pkgsrc work.

Revision 1.11 / (download) - annotate - [select for diffs], Mon Dec 5 23:55:05 2005 UTC (17 years, 2 months ago) by rillig
Branch: MAIN
Changes since 1.10: +4 -4 lines
Diff to previous 1.10 (colored)

Ran "pkglint --autofix", which corrected some of the quoting issues in
CONFIGURE_ARGS.

Revision 1.10 / (download) - annotate - [select for diffs], Mon Dec 5 20:50:00 2005 UTC (17 years, 2 months ago) by rillig
Branch: MAIN
Changes since 1.9: +2 -2 lines
Diff to previous 1.9 (colored)

Fixed pkglint warnings. The warnings are mostly quoting issues, for
example MAKE_ENV+=FOO=${BAR} is changed to MAKE_ENV+=FOO=${BAR:Q}. Some
other changes are outlined in

    http://mail-index.netbsd.org/tech-pkg/2005/12/02/0034.html

Revision 1.9 / (download) - annotate - [select for diffs], Sun Oct 23 20:16:52 2005 UTC (17 years, 3 months ago) by jlam
Branch: MAIN
Changes since 1.8: +2 -2 lines
Diff to previous 1.8 (colored)

Update postgresql80-related packages to 8.0.4.  On updating from any
previous 8.0.x release, no dump-and-restore is necessary.  Changes
from version 8.0.3 include:

postgresql80-client:
     - Clarify comment for pgsql-hier-query option to note that it is
       considered buggy by PostgreSQL developers.
     * Make psql -f filename return a nonzero exit code when opening the
       file fails
     * Change pg_dump to handle inherited check constraints more reliably

postgresql80-server:
     * Fix error that allowed "VACUUM" to remove ctid chains too soon, and
       add more checking in code that follows ctid links
       This fixes a long-standing problem that could cause crashes in very
       rare circumstances.
     * Fix CHAR() to properly pad spaces to the specified length when
       using a multiple-byte character set (Yoshiyuki Asaba)
       In prior releases, the padding of CHAR() was incorrect because it
       only padded to the specified number of bytes without considering
       how many characters were stored.
     * Force a checkpoint before committing "CREATE DATABASE"
       This should fix recent reports of "index is not a btree" failures
       when a crash occurs shortly after "CREATE DATABASE".
     * Fix the sense of the test for read-only transaction in "COPY"
       The code formerly prohibited "COPY TO", where it should prohibit
       "COPY FROM".
     * Handle consecutive embedded newlines in "COPY" CSV-mode input
     * Fix date_trunc(week) for dates near year end
     * Fix planning problem with outer-join ON clauses that reference only
       the inner-side relation
     * Further fixes for x FULL JOIN y ON true corner cases
     * Fix overenthusiastic optimization of x IN (SELECT DISTINCT ...) and
       related cases
     * Fix mis-planning of queries with small LIMIT values due to poorly
       thought out "fuzzy" cost comparison
     * Make array_in and array_recv more paranoid about validating their
       OID parameter
     * Fix missing rows in queries like UPDATE a=... WHERE a... with GiST
       index on column a
     * Improve robustness of datetime parsing
     * Improve checking for partially-written WAL pages
     * Improve robustness of signal handling when SSL is enabled
     * Improve MIPS and M68K spinlock code
     * Don't try to open more than max_files_per_process files during
       postmaster startup
     * Various memory leakage fixes
     * Various portability improvements
     * Update timezone data files
     * Fix PL/PgSQL to handle var := var correctly when the variable is of
       pass-by-reference type

postgresql80-plperl:
     * Fix PL/Perl %_SHARED so it's actually shared

Revision 1.8 / (download) - annotate - [select for diffs], Mon Aug 8 23:19:26 2005 UTC (17 years, 6 months ago) by jlam
Branch: MAIN
CVS Tags: pkgsrc-2005Q3-base, pkgsrc-2005Q3
Changes since 1.7: +19 -1 lines
Diff to previous 1.7 (colored)

Expose a new variable PGSQL_BLCKSZ for package builders to tweak so
as to optimize PostgreSQL performance.  This is a fairly expert option
and represents the size in bytes of a PostgreSQL disk page, defaulting
to 8K.

Revision 1.7 / (download) - annotate - [select for diffs], Mon Aug 8 22:20:34 2005 UTC (17 years, 6 months ago) by jlam
Branch: MAIN
Changes since 1.6: +2 -2 lines
Diff to previous 1.6 (colored)

Rename the POSTGRESQL_* variables to PGSQL_* to match the naming
convention for other PostgreSQL variables in pkgsrc.

Revision 1.6 / (download) - annotate - [select for diffs], Fri Aug 5 19:43:44 2005 UTC (17 years, 6 months ago) by jlam
Branch: MAIN
Changes since 1.5: +66 -47 lines
Diff to previous 1.5 (colored)

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
  flags.

* Remove zlib/buildlink3.mk from postgresql80-client/buildlink3.mk
  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
  DOES NOT WORK YET.

* 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

Revision 1.5 / (download) - annotate - [select for diffs], Sun May 22 20:07:46 2005 UTC (17 years, 8 months ago) by jlam
Branch: MAIN
CVS Tags: pkgsrc-2005Q2-base, pkgsrc-2005Q2
Changes since 1.4: +2 -2 lines
Diff to previous 1.4 (colored)

Remove USE_GNU_TOOLS and replace with the correct USE_TOOLS definitions:

	USE_GNU_TOOLS	-> USE_TOOLS
	awk		-> gawk
	m4		-> gm4
	make		-> gmake
	sed		-> gsed
	yacc		-> bison

Revision 1.4 / (download) - annotate - [select for diffs], Sun May 15 12:31:57 2005 UTC (17 years, 8 months ago) by recht
Branch: MAIN
Changes since 1.3: +5 -12 lines
Diff to previous 1.3 (colored)

Update to PostgreSQL 8.0.3

   This release contains a variety of fixes from 8.0.2, including several
   security-related issues.
     __________________________________________________________________

Migration to version 8.0.3

   A dump/restore is not required for those running 8.0.X. However, it is
   one possible way of handling two significant security problems that
   have been found in the initial contents of 8.0.X system catalogs. A
   dump/initdb/reload sequence using 8.0.3's initdb will automatically
   correct these problems.

   The larger security problem is that the built-in character set encoding
   conversion functions can be invoked from SQL commands by unprivileged
   users, but the functions were not designed for such use and are not
   secure against malicious choices of arguments. The fix involves
   changing the declared parameter list of these functions so that they
   can no longer be invoked from SQL commands. (This does not affect their
   normal use by the encoding conversion machinery.)

   The lesser problem is that the "contrib/tsearch2" module creates
   several functions that are misdeclared to return internal when they do
   not accept internal arguments. This breaks type safety for all
   functions using internal arguments.

   It is strongly recommended that all installations repair these errors,
   either by initdb or by following the manual repair procedure given
   below. The errors at least allow unprivileged database users to crash
   their server process, and may allow unprivileged users to gain the
   privileges of a database superuser.

   If you wish not to do an initdb, perform the same manual repair
   procedures shown in the 7.4.8 release notes.
     __________________________________________________________________

Changes

     * Change encoding function signature to prevent misuse
     * Change "contrib/tsearch2" to avoid unsafe use of INTERNAL function
       results
     * Guard against incorrect second parameter to record_out
     * Repair ancient race condition that allowed a transaction to be seen
       as committed for some purposes (eg SELECT FOR UPDATE) slightly
       sooner than for other purposes
       This is an extremely serious bug since it could lead to apparent
       data inconsistencies being briefly visible to applications.
     * Repair race condition between relation extension and VACUUM
       This could theoretically have caused loss of a page's worth of
       freshly-inserted data, although the scenario seems of very low
       probability. There are no known cases of it having caused more than
       an Assert failure.
     * Fix comparisons of TIME WITH TIME ZONE values
       The comparison code was wrong in the case where the
       --enable-integer-datetimes configuration switch had been used.
       NOTE: if you have an index on a TIME WITH TIME ZONE column, it will
       need to be "REINDEX"ed after installing this update, because the
       fix corrects the sort order of column values.
     * Fix EXTRACT(EPOCH) for TIME WITH TIME ZONE values
     * Fix mis-display of negative fractional seconds in INTERVAL values
       This error only occurred when the --enable-integer-datetimes
       configuration switch had been used.
     * Fix pg_dump to dump trigger names containing % correctly (Neil)
     * Still more 64-bit fixes for "contrib/intagg"
     * Prevent incorrect optimization of functions returning RECORD
     * Prevent crash on COALESCE(NULL,NULL)
     * Fix Borland makefile for libpq
     * Fix "contrib/btree_gist" for timetz type (Teodor)
     * Make "pg_ctl" check the PID found in "postmaster.pid" to see if it
       is still a live process
     * Fix "pg_dump"/"pg_restore" problems caused by addition of dump
       timestamps
     * Fix interaction between materializing holdable cursors and firing
       deferred triggers during transaction commit
     * Fix memory leak in SQL functions returning pass-by-reference data
       types

pkgsrc specific change:
Instead of setting CONFIGURE_ART let configure find the template to use
iteself.

Revision 1.3 / (download) - annotate - [select for diffs], Mon Apr 11 21:45:15 2005 UTC (17 years, 9 months ago) by tv
Branch: MAIN
Changes since 1.2: +1 -2 lines
Diff to previous 1.2 (colored)

Remove USE_BUILDLINK3 and NO_BUILDLINK; these are no longer used.

Revision 1.2 / (download) - annotate - [select for diffs], Mon Apr 11 20:34:43 2005 UTC (17 years, 9 months ago) by recht
Branch: MAIN
Changes since 1.1: +19 -10 lines
Diff to previous 1.1 (colored)

update to PostgreSQL 8.0.2
While at it do some structual changes to packages and merge
the lib and docs package has been merged into the client package.
Also enable Rendezvous support on Darwin.

Changes

     * Increment the major version number of all interface libraries
       (Bruce)
       This should have been done in 8.0.0. It is required so 7.4.X
       versions of PostgreSQL client applications, like psql, can be used
       on the same machine as 8.0.X applications. This might require
       re-linking user applications that use these libraries.
     * Add Windows-only wal_sync_method setting of "fsync_writethrough"
       (Magnus, Bruce)
       This setting causes PostgreSQL to write through any disk-drive
       write cache when writing to WAL. This behavior was formerly called
       "fsync", but was renamed because it acts quite differently from
       "fsync" on other platforms.
     * Enable the wal_sync_method setting of "open_datasync" on Windows,
       and make it the default for that platform (Magnus, Bruce)
       Because the default is no longer "fsync_writethrough", data loss is
       possible during a power failure if the disk drive has write caching
       enabled. To turn off the write cache on Windows, from the Device
       Manager, choose the drive properties, then Policies.
     * New cache management algorithm 2Q replaces ARC (Tom)
       This was done to avoid a pending US patent on ARC. The 2Q code
       might be a few percentage points slower than ARC for some work
       loads. A better cache management algorithm will appear in 8.1.
     * Planner adjustments to improve behavior on freshly-created tables
       (Tom)
     * Allow plpgsql to assign to an element of an array that is initially
       NULL (Tom)
       Formerly the array would remain NULL, but now it becomes a
       single-element array. The main SQL engine was changed to handle
       "UPDATE" of a null array value this way in 8.0, but the similar
       case in plpgsql was overlooked.
     * Convert \r\n and \r to \n in plpython function bodies (Michael
       Fuhr)
       This prevents syntax errors when plpython code is written on a
       Windows or Mac client.
     * Allow SPI cursors to handle utility commands that return rows, such
       as "EXPLAIN" (Tom)
     * Fix "CLUSTER" failure after "ALTER TABLE SET WITHOUT OIDS" (Tom)
     * Reduce memory usage of "ALTER TABLE ADD COLUMN" (Neil)
     * Fix "ALTER LANGUAGE RENAME" (Tom)
     * Document the Windows-only register and unregister options of pg_ctl
       (Magnus)
     * Ensure operations done during backend shutdown are counted by
       statistics collector
       This is expected to resolve reports of pg_autovacuum not vacuuming
       the system catalogs often enough -- it was not being told about
       catalog deletions caused by temporary table removal during backend
       exit.
     * Change the Windows default for configuration parameter
       log_destination to "eventlog" (Magnus)
       By default, a server running on Windows will now send log output to
       the Windows event logger rather than standard error.
     * Make Kerberos authentication work on Windows (Magnus)
     * Allow "ALTER DATABASE RENAME" by superusers who aren't flagged as
       having CREATEDB privilege (Tom)
     * Modify WAL log entries for "CREATE" and "DROP DATABASE" to not
       specify absolute paths (Tom)
       This allows point-in-time recovery on a different machine with
       possibly different database location. Note that "CREATE TABLESPACE"
       still poses a hazard in such situations.
     * Fix crash from a backend exiting with an open transaction that
       created a table and opened a cursor on it (Tom)
     * Fix array_map() so it can call PL functions (Tom)
     * Several "contrib/tsearch2" and "contrib/btree_gist" fixes (Teodor)
     * Fix crash of some "contrib/pgcrypto" functions on some platforms
       (Marko Kreen)
     * Fix "contrib/intagg" for 64-bit platforms (Tom)
     * Fix ecpg bugs in parsing of "CREATE" statement (Michael)
     * Work around gcc bug on powerpc and amd64 causing problems in ecpg
       (Christof Petig)
     * Do not use locale-aware versions of upper(), lower(), and initcap()
       when the locale is C (Bruce)
       This allows these functions to work on platforms that generate
       errors for non-7-bit data when the locale is C.
     * Fix quote_ident() to quote names that match keywords (Tom)
     * Fix to_date() to behave reasonably when CC and YY fields are both
       used (Karel)
     * Prevent to_char(interval) from failing when given a zero-month
       interval (Tom)
     * Fix wrong week returned by date_trunc('week') (Bruce)
       date_trunc('week') returned the wrong year for the first few days
       of January in some years.
     * Use the correct default mask length for class D addresses in INET
       data types (Tom)

Revision 1.1.1.1 / (download) - annotate - [select for diffs] (vendor branch), Sun Feb 6 12:32:05 2005 UTC (18 years ago) by jdolecek
Branch: TNF
CVS Tags: pkgsrc-base, pkgsrc-2005Q1-base, pkgsrc-2005Q1
Changes since 1.1: +0 -0 lines
Diff to previous 1.1 (colored)

PostgreSQL 8.0.1 packages. A dump/restore using pg_dump is required
for those wishing to migrate data from any previous release.

Major changes relative to 7.4.x:
* Savepoints
* Point-in-Time recovery
* Tablespaces
* Improved buffer management
* ALTER TABLE column management improvements

Full list of changes is available at:

	http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0

Also note that PostgreSQL server listens also on localhost (127.0.0.1)
by default now.

Revision 1.1 / (download) - annotate - [select for diffs], Sun Feb 6 12:32:05 2005 UTC (18 years ago) by jdolecek
Branch: MAIN

Initial revision

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.




CVSweb <webmaster@jp.NetBSD.org>