Welcome PostgreSQL 8.4

After many years of development, PostgreSQL has become feature-complete in many areas.
This release shows a targeted approach to adding features (e.g., authentication,
monitoring, space reuse), and adds capabilities defined in the later SQL standards.
The major areas of enhancement are:

Windowing Functions
Common Table Expressions and Recursive Queries
Default and variadic parameters for functions
Parallel Restore
Column Permissions
Per-database locale settings
Improved hash indexes
Improved join performance for EXISTS and NOT EXISTS queries
Easier-to-use Warm Standby
Automatic sizing of the Free Space Map
Visibility Map (greatly reduces vacuum overhead for slowly-changing tables)
Version-aware psql (backslash commands work against older servers)
Support SSL certificates for user authentication
Per-function runtime statistics
Easy editing of functions in psql
New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin

URL: http://www.postgresql.org/docs/8.4/interactive/release-8-4.html

1 files changed, 28 insertions, 3 deletions

diff --git a/databases/postgresql84-server/pkg-plist-client b/databases/postgresql84-server/pkg-plist-client
index c219ef4dff82..62ea592ed3ac 100644
--- a/databases/postgresql84-server/pkg-plist-client
+++ b/databases/postgresql84-server/pkg-plist-client
@@ -14,6 +14,7 @@ bin/psql
 bin/reindexdb
 bin/vacuumdb
 include/ecpg_config.h
+include/libpq-events.h
 include/postgresql/server/access/attnum.h
 include/postgresql/server/access/clog.h
 include/postgresql/server/access/genam.h
@@ -37,6 +38,7 @@ include/postgresql/server/access/sdir.h
 include/postgresql/server/access/skey.h
 include/postgresql/server/access/slru.h
 include/postgresql/server/access/subtrans.h
+include/postgresql/server/access/sysattr.h
 include/postgresql/server/access/transam.h
 include/postgresql/server/access/tupdesc.h
 include/postgresql/server/access/tupmacs.h
@@ -44,6 +46,7 @@ include/postgresql/server/access/tuptoaster.h
 include/postgresql/server/access/twophase.h
 include/postgresql/server/access/twophase_rmgr.h
 include/postgresql/server/access/valid.h
+include/postgresql/server/access/visibilitymap.h
 include/postgresql/server/access/xact.h
 include/postgresql/server/access/xlog.h
 include/postgresql/server/access/xlog_internal.h
@@ -54,6 +57,7 @@ include/postgresql/server/c.h
 include/postgresql/server/catalog/catalog.h
 include/postgresql/server/catalog/catversion.h
 include/postgresql/server/catalog/dependency.h
+include/postgresql/server/catalog/genbki.h
 include/postgresql/server/catalog/heap.h
 include/postgresql/server/catalog/index.h
 include/postgresql/server/catalog/indexing.h
@@ -66,18 +70,21 @@ include/postgresql/server/catalog/pg_attrdef.h
 include/postgresql/server/catalog/pg_attribute.h
 include/postgresql/server/catalog/pg_auth_members.h
 include/postgresql/server/catalog/pg_authid.h
-include/postgresql/server/catalog/pg_autovacuum.h
 include/postgresql/server/catalog/pg_cast.h
 include/postgresql/server/catalog/pg_class.h
 include/postgresql/server/catalog/pg_constraint.h
 include/postgresql/server/catalog/pg_control.h
 include/postgresql/server/catalog/pg_conversion.h
+include/postgresql/server/catalog/pg_conversion_fn.h
 include/postgresql/server/catalog/pg_database.h
 include/postgresql/server/catalog/pg_depend.h
 include/postgresql/server/catalog/pg_description.h
 include/postgresql/server/catalog/pg_enum.h
+include/postgresql/server/catalog/pg_foreign_data_wrapper.h
+include/postgresql/server/catalog/pg_foreign_server.h
 include/postgresql/server/catalog/pg_index.h
 include/postgresql/server/catalog/pg_inherits.h
+include/postgresql/server/catalog/pg_inherits_fn.h
 include/postgresql/server/catalog/pg_language.h
 include/postgresql/server/catalog/pg_largeobject.h
 include/postgresql/server/catalog/pg_listener.h
@@ -87,6 +94,7 @@ include/postgresql/server/catalog/pg_operator.h
 include/postgresql/server/catalog/pg_opfamily.h
 include/postgresql/server/catalog/pg_pltemplate.h
 include/postgresql/server/catalog/pg_proc.h
+include/postgresql/server/catalog/pg_proc_fn.h
 include/postgresql/server/catalog/pg_rewrite.h
 include/postgresql/server/catalog/pg_shdepend.h
 include/postgresql/server/catalog/pg_shdescription.h
@@ -99,6 +107,9 @@ include/postgresql/server/catalog/pg_ts_dict.h
 include/postgresql/server/catalog/pg_ts_parser.h
 include/postgresql/server/catalog/pg_ts_template.h
 include/postgresql/server/catalog/pg_type.h
+include/postgresql/server/catalog/pg_type_fn.h
+include/postgresql/server/catalog/pg_user_mapping.h
+include/postgresql/server/catalog/storage.h
 include/postgresql/server/catalog/toasting.h
 include/postgresql/server/commands/alter.h
 include/postgresql/server/commands/async.h
@@ -139,6 +150,7 @@ include/postgresql/server/executor/nodeBitmapAnd.h
 include/postgresql/server/executor/nodeBitmapHeapscan.h
 include/postgresql/server/executor/nodeBitmapIndexscan.h
 include/postgresql/server/executor/nodeBitmapOr.h
+include/postgresql/server/executor/nodeCtescan.h
 include/postgresql/server/executor/nodeFunctionscan.h
 include/postgresql/server/executor/nodeGroup.h
 include/postgresql/server/executor/nodeHash.h
@@ -148,6 +160,7 @@ include/postgresql/server/executor/nodeLimit.h
 include/postgresql/server/executor/nodeMaterial.h
 include/postgresql/server/executor/nodeMergejoin.h
 include/postgresql/server/executor/nodeNestloop.h
+include/postgresql/server/executor/nodeRecursiveunion.h
 include/postgresql/server/executor/nodeResult.h
 include/postgresql/server/executor/nodeSeqscan.h
 include/postgresql/server/executor/nodeSetOp.h
@@ -157,6 +170,8 @@ include/postgresql/server/executor/nodeSubqueryscan.h
 include/postgresql/server/executor/nodeTidscan.h
 include/postgresql/server/executor/nodeUnique.h
 include/postgresql/server/executor/nodeValuesscan.h
+include/postgresql/server/executor/nodeWindowAgg.h
+include/postgresql/server/executor/nodeWorktablescan.h
 include/postgresql/server/executor/spi.h
 include/postgresql/server/executor/spi_priv.h
 include/postgresql/server/executor/tstoreReceiver.h
@@ -211,6 +226,7 @@ include/postgresql/server/optimizer/geqo_selection.h
 include/postgresql/server/optimizer/joininfo.h
 include/postgresql/server/optimizer/pathnode.h
 include/postgresql/server/optimizer/paths.h
+include/postgresql/server/optimizer/placeholder.h
 include/postgresql/server/optimizer/plancat.h
 include/postgresql/server/optimizer/planmain.h
 include/postgresql/server/optimizer/planner.h
@@ -221,12 +237,14 @@ include/postgresql/server/optimizer/subselect.h
 include/postgresql/server/optimizer/tlist.h
 include/postgresql/server/optimizer/var.h
 include/postgresql/server/parser/analyze.h
+include/postgresql/server/parser/gram.h
 include/postgresql/server/parser/gramparse.h
 include/postgresql/server/parser/keywords.h
-include/postgresql/server/parser/parse.h
+include/postgresql/server/parser/kwlist.h
 include/postgresql/server/parser/parse_agg.h
 include/postgresql/server/parser/parse_clause.h
 include/postgresql/server/parser/parse_coerce.h
+include/postgresql/server/parser/parse_cte.h
 include/postgresql/server/parser/parse_expr.h
 include/postgresql/server/parser/parse_func.h
 include/postgresql/server/parser/parse_node.h
@@ -280,6 +298,7 @@ include/postgresql/server/port/win32_msvc/sys/param.h
 include/postgresql/server/port/win32_msvc/sys/time.h
 include/postgresql/server/port/win32_msvc/unistd.h
 include/postgresql/server/port/win32_msvc/utime.h
+include/postgresql/server/portability/instr_time.h
 include/postgresql/server/postgres.h
 include/postgresql/server/postgres_ext.h
 include/postgresql/server/postgres_fe.h
@@ -344,10 +363,11 @@ include/postgresql/server/storage/bufmgr.h
 include/postgresql/server/storage/bufpage.h
 include/postgresql/server/storage/fd.h
 include/postgresql/server/storage/freespace.h
+include/postgresql/server/storage/fsm_internals.h
+include/postgresql/server/storage/indexfsm.h
 include/postgresql/server/storage/ipc.h
 include/postgresql/server/storage/item.h
 include/postgresql/server/storage/itemid.h
-include/postgresql/server/storage/itempos.h
 include/postgresql/server/storage/itemptr.h
 include/postgresql/server/storage/large_object.h
 include/postgresql/server/storage/lmgr.h
@@ -418,11 +438,14 @@ include/postgresql/server/utils/pg_lzcompress.h
 include/postgresql/server/utils/pg_rusage.h
 include/postgresql/server/utils/plancache.h
 include/postgresql/server/utils/portal.h
+include/postgresql/server/utils/probes.h
 include/postgresql/server/utils/ps_status.h
 include/postgresql/server/utils/rel.h
 include/postgresql/server/utils/relcache.h
 include/postgresql/server/utils/resowner.h
 include/postgresql/server/utils/selfuncs.h
+include/postgresql/server/utils/snapmgr.h
+include/postgresql/server/utils/snapshot.h
 include/postgresql/server/utils/syscache.h
 include/postgresql/server/utils/timestamp.h
 include/postgresql/server/utils/tqual.h
@@ -433,6 +456,7 @@ include/postgresql/server/utils/tzparser.h
 include/postgresql/server/utils/uuid.h
 include/postgresql/server/utils/varbit.h
 include/postgresql/server/utils/xml.h
+include/postgresql/server/windowapi.h
 @dirrm include/postgresql/server/utils
 @dirrm include/postgresql/server/tsearch/dicts
 @dirrm include/postgresql/server/tsearch
@@ -443,6 +467,7 @@ include/postgresql/server/utils/xml.h
 @dirrm include/postgresql/server/rewrite
 @dirrm include/postgresql/server/regex
 @dirrm include/postgresql/server/postmaster
+@dirrm include/postgresql/server/portability
 @dirrm include/postgresql/server/port/win32_msvc/sys
 @dirrm include/postgresql/server/port/win32_msvc
 @dirrm include/postgresql/server/port/win32/sys