|
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.
|
|
* Query language enhancements including "INSERT/UPDATE/DELETE
RETURNING", multirow VALUES lists, and optional target-table alias
in "UPDATE"/"DELETE"
* Index creation without blocking concurrent
"INSERT"/"UPDATE"/"DELETE" operations
* Many query optimization improvements, including support for
reordering outer joins
* Improved sorting performance with lower memory usage
* More efficient locking with better concurrency
* More efficient vacuuming
* Easier administration of warm standby servers
* New FILLFACTOR support for tables and indexes
* Monitoring, logging, and performance tuning additions
* More control over creating and dropping objects
* Table inheritance relationships can be defined for and removed from
pre-existing tables
* "COPY TO" can copy the output of an arbitrary "SELECT" statement
* Array improvements, including nulls in arrays
* Aggregate-function improvements, including multiple-input
aggregates and SQL:2003 statistical functions
* Many "contrib/" improvements
|
