CVS commit: pkgsrc/databases

[Adam Ciarcinski <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Thu Sep 10 10:07:17 UTC 2009

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

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


To generate a diff of this commit:
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql83/Makefile.common \
    pkgsrc/databases/postgresql83/distinfo
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql83-client/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql83-client/PLIST

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