Module Name:	pkgsrc
Committed By:	adam
Date:		Wed Sep 19 20:02:12 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.5:
* Prevent index corruption when a transaction inserts rows and then
  aborts close to the end of a concurrent "VACUUM" on the same table
* Fix ALTER DOMAIN ADD CONSTRAINT for cases involving domains over
  domains
* Make "CREATE DOMAIN ... DEFAULT NULL" work properly
* Fix some planner problems with outer joins, notably poor size
  estimation for t1 LEFT JOIN t2 WHERE t2.col IS NULL
* Allow the interval data type to accept input consisting only of
  milliseconds or microseconds
* Allow timezone name to appear before the year in timestamp input
* Fixes for GIN indexes used by "/contrib/tsearch2"
* Speed up rtree index insertion
* 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
* Fix stddev_pop(numeric) and var_pop(numeric)
* Prevent "REINDEX" and "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 and semaphore improvements
* Make "pg_ctl -w" work properly in Windows service mode
* Fix memory allocation bug when using MIT Kerberos on Windows
* 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
* Restrict "/contrib/pgstattuple" functions to superusers, for
  security reasons
* Do not let "/contrib/intarray" try to make its GIN opclass the
  default (this caused problems at dump/restore)


To generate a diff of this commit:
cvs rdiff -r1.6 -r1.7 pkgsrc/databases/postgresql82/Makefile.common
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/postgresql82/distinfo
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/postgresql82-client/PLIST
cvs rdiff -r1.3 -r1.4 pkgsrc/databases/postgresql82-server/PLIST

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