Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2007-09-19 22:02:12
Message id: 20070919200212.BB81C21507@cvs.netbsd.org

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)

Files:
RevisionActionfile
1.7modifypkgsrc/databases/postgresql82/Makefile.common
1.8modifypkgsrc/databases/postgresql82/distinfo
1.6modifypkgsrc/databases/postgresql82-client/PLIST
1.4modifypkgsrc/databases/postgresql82-server/PLIST