Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2009-09-10 12:07:17
Message id: 20090910100717.9141D175D0@cvs.netbsd.org

Log Message:
Changes 8.3.8:
* Fix Windows shared-memory allocation code
* Force WAL segment switch during pg_start_backup()
* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
  security-definer functions
* Make "LOAD" of an already-loaded loadable module into a no-op
* Disallow empty passwords during LDAP authentication
* Fix handling of sub-SELECTs appearing in the arguments of an
  outer-level aggregate function
* Fix bugs associated with fetching a whole-row value from the output
  of a Sort or Materialize plan node
* Prevent synchronize_seqscans from changing the results of
  scrollable and WITH HOLD cursors
* Revert planner change that disabled partial-index and constraint
  exclusion optimizations when there were more than 100 clauses in an
  AND or OR list
* Fix hash calculation for data type interval
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with 'HH'/'HH12'
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
  and integer datetimes are in use
* Fix calculation of distance between a point and a line segment
* Fix money data type to work in locales where currency amounts have
  no fractional digits, e.g. Japan
* Fix LIKE for case where pattern contains %_
* Properly round datetime input like 00:12:57.9999999999999999999999999999
* Fix memory leaks in XML operations
* Fix poor choice of page split point in GiST R-tree operator classes
* Ensure that a "fast shutdown" request will forcibly terminate open
  sessions, even if a "smart shutdown" was already in progress
* Avoid performance degradation in bulk inserts into GIN indexes when
  the input values are (nearly) in sorted order
* Correctly enforce NOT NULL domain constraints in some contexts in
  PL/pgSQL
* Fix portability issues in plperl initialization
* Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is
  empty
* Improve pg_dump's efficiency when there are many large objects
* Use SIGUSR1, not SIGQUIT, as the failover signal for pg_standby

Files:
RevisionActionfile
1.8modifypkgsrc/databases/postgresql83/Makefile.common
1.8modifypkgsrc/databases/postgresql83/distinfo
1.8modifypkgsrc/databases/postgresql83-client/Makefile
1.10modifypkgsrc/databases/postgresql83-client/PLIST