Introduce the world to PostgreSQL 7.4! By and large this release is

regarded as a major release with features with interest to those with
large databases.  The updates are extensive and the best source of info
is in the release notes.  Enjoy and direct questions to database@!

Release notes:
http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4

PR:		ports/59403, ports/59404, ports/59393, ports/59394,
		ports/59395, ports/59397, ports/59398, ports/59402, &&
		ports/59401
Submitted by:	maintainer
Approved by:	marcus (portmgr@ hat)

1 files changed, 98 insertions, 36 deletions

diff --git a/databases/postgresql-devel-server/pkg-plist b/databases/postgresql-devel-server/pkg-plist
index effd8e4f2f71..6c4ba1c3568b 100644
--- a/databases/postgresql-devel-server/pkg-plist
+++ b/databases/postgresql-devel-server/pkg-plist
@@ -33,21 +33,38 @@ include/postgresql/internal/libpq-int.h
 include/postgresql/internal/postgres_fe.h
 include/postgresql/internal/pqexpbuffer.h
 @dirrm include/postgresql/internal
+include/compatlib.h
+include/datetime.h
+include/decimal.h
+include/ecpg_informix.h
 include/ecpgerrno.h
 include/ecpglib.h
 include/ecpgtype.h
 include/libpq-fe.h
 include/pg_config.h
 include/pg_config_os.h
+include/pgtypes_date.h
+include/pgtypes_error.h
+include/pgtypes_interval.h
+include/pgtypes_numeric.h
+include/pgtypes_timestamp.h
 include/postgres_ext.h
 include/sql3types.h
 include/sqlca.h
+include/sqlda.h
+include/sqltypes.h
 lib/libecpg.a
 lib/libecpg.so
-lib/libecpg.so.3
+lib/libecpg.so.4
+lib/libecpg_compat.a
+lib/libecpg_compat.so
+lib/libecpg_compat.so.1
 lib/libpq.a
 lib/libpq.so
 lib/libpq.so.3
+lib/libpgtypes.a
+lib/libpgtypes.so
+lib/libpgtypes.so.1
 %%SERVER%%lib/postgresql/ascii_and_mic.so
 %%SERVER%%lib/postgresql/cyrillic_and_mic.so
 %%SERVER%%lib/postgresql/euc_cn_and_mic.so
@@ -77,57 +94,93 @@ lib/libpq.so.3
 %%SERVER%%lib/postgresql/plpgsql.so
 @unexec rmdir %D/lib/postgresql 2>/dev/null || true
 %%SERVER%%share/postgresql/502.pgsql
-%%SERVER%%share/postgresql/postgres.bki
-%%SERVER%%share/postgresql/postgres.description
+%%SERVER%%share/postgresql/conversion_create.sql
+%%SERVER%%share/postgresql/information_schema.sql
 %%SERVER%%share/postgresql/pg_hba.conf.sample
 %%SERVER%%share/postgresql/pg_ident.conf.sample
+%%SERVER%%share/postgresql/pg_service.conf.sample
+%%SERVER%%share/postgresql/postgres.bki
+%%SERVER%%share/postgresql/postgres.description
 %%SERVER%%share/postgresql/postgresql.conf.sample
-%%SERVER%%share/postgresql/conversion_create.sql
+%%SERVER%%share/postgresql/sql_features.txt
 share/postgresql/post-install-notes
 @unexec rmdir %D/share/postgresql 2>/dev/null || true
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_controldata.mo
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/cs/LC_MESSAGES/pgscripts.mo
 %%GETTEXT%%share/locale/cs/LC_MESSAGES/psql.mo
-%%GETTEXT%%share/locale/cs/LC_MESSAGES/libpq.mo
 %%GETTEXT%%share/locale/de/LC_MESSAGES/pg_dump.mo
 %%GETTEXT%%share/locale/de/LC_MESSAGES/psql.mo
 %%GETTEXT%%share/locale/de/LC_MESSAGES/pg_controldata.mo
 %%GETTEXT%%share/locale/de/LC_MESSAGES/pg_resetxlog.mo
 %%GETTEXT%%share/locale/de/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/de/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/es/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/hr/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/it/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_dump.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/nb/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq.mo
 %%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_dump.mo
 %%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_dump.mo
-%%GETTEXT%%share/locale/ru/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq.mo
 %%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_dump.mo
 %%GETTEXT%%share/locale/ru/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/ru/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump.mo
-%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/ru/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pg_resetxlog.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/sl/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq.mo
 %%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_dump.mo
 %%GETTEXT%%share/locale/sv/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/sv/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump.mo
-%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/sv/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq.mo
 %%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_controldata.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_dump.mo
 %%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/libpq.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/pgscripts.mo
+%%GETTEXT%%share/locale/zh_CN/LC_MESSAGES/psql.mo
+%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/libpq.mo
 %%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/pg_dump.mo
 %%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/psql.mo
-%%GETTEXT%%share/locale/zh_TW/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/fr/LC_MESSAGES/psql.mo
-%%GETTEXT%%share/locale/fr/LC_MESSAGES/pg_controldata.mo
-%%GETTEXT%%share/locale/fr/LC_MESSAGES/libpq.mo
-%%GETTEXT%%share/locale/hu/LC_MESSAGES/psql.mo
-%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_controldata.mo
-%%GETTEXT%%share/locale/hu/LC_MESSAGES/pg_resetxlog.mo
-%%GETTEXT%%share/locale/es/LC_MESSAGES/pg_controldata.mo
-%%GETTEXT%%share/locale/es/LC_MESSAGES/libpq.mo
 %%SERVER%%%%GETTEXT%%share/locale/cs/LC_MESSAGES/postgres.mo
 %%SERVER%%%%GETTEXT%%share/locale/de/LC_MESSAGES/postgres.mo
 %%SERVER%%%%GETTEXT%%share/locale/es/LC_MESSAGES/postgres.mo
 %%SERVER%%%%GETTEXT%%share/locale/hr/LC_MESSAGES/postgres.mo
 %%SERVER%%%%GETTEXT%%share/locale/hu/LC_MESSAGES/postgres.mo
+%%SERVER%%%%GETTEXT%%share/locale/it/LC_MESSAGES/postgres.mo
+%%SERVER%%%%GETTEXT%%share/locale/nb/LC_MESSAGES/postgres.mo
+%%SERVER%%%%GETTEXT%%share/locale/pt_BR/LC_MESSAGES/postgres.mo
 %%SERVER%%%%GETTEXT%%share/locale/ru/LC_MESSAGES/postgres.mo
 %%SERVER%%%%GETTEXT%%share/locale/sv/LC_MESSAGES/postgres.mo
 %%SERVER%%%%GETTEXT%%share/locale/tr/LC_MESSAGES/postgres.mo
@@ -173,6 +226,7 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/access/rtscan.h
 %%SERVER%%include/postgresql/server/access/sdir.h
 %%SERVER%%include/postgresql/server/access/skey.h
+%%SERVER%%include/postgresql/server/access/slru.h
 %%SERVER%%include/postgresql/server/access/strat.h
 %%SERVER%%include/postgresql/server/access/transam.h
 %%SERVER%%include/postgresql/server/access/tupdesc.h
@@ -222,6 +276,7 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/catalog/pg_trigger.h
 %%SERVER%%include/postgresql/server/catalog/pg_type.h
 %%SERVER%%include/postgresql/server/catalog/pg_version.h
+%%SERVER%%include/postgresql/server/commands/alter.h
 %%SERVER%%include/postgresql/server/commands/async.h
 %%SERVER%%include/postgresql/server/commands/cluster.h
 %%SERVER%%include/postgresql/server/commands/comment.h
@@ -238,6 +293,7 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/commands/sequence.h
 %%SERVER%%include/postgresql/server/commands/tablecmds.h
 %%SERVER%%include/postgresql/server/commands/trigger.h
+%%SERVER%%include/postgresql/server/commands/typecmds.h
 %%SERVER%%include/postgresql/server/commands/user.h
 %%SERVER%%include/postgresql/server/commands/vacuum.h
 %%SERVER%%include/postgresql/server/commands/variable.h
@@ -271,6 +327,7 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/executor/nodeUnique.h
 %%SERVER%%include/postgresql/server/executor/spi.h
 %%SERVER%%include/postgresql/server/executor/spi_priv.h
+%%SERVER%%include/postgresql/server/executor/tstoreReceiver.h
 %%SERVER%%include/postgresql/server/executor/tuptable.h
 %%SERVER%%include/postgresql/server/lib/dllist.h
 %%SERVER%%include/postgresql/server/lib/lispsort.h
@@ -279,14 +336,15 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/libpq/be-fsstubs.h
 %%SERVER%%include/postgresql/server/libpq/crypt.h
 %%SERVER%%include/postgresql/server/libpq/hba.h
+%%SERVER%%include/postgresql/server/libpq/ip.h
 %%SERVER%%include/postgresql/server/libpq/libpq-be.h
 %%SERVER%%include/postgresql/server/libpq/libpq-fs.h
 %%SERVER%%include/postgresql/server/libpq/libpq.h
-%%SERVER%%include/postgresql/server/libpq/password.h
 %%SERVER%%include/postgresql/server/libpq/pqcomm.h
 %%SERVER%%include/postgresql/server/libpq/pqformat.h
 %%SERVER%%include/postgresql/server/libpq/pqsignal.h
 %%SERVER%%include/postgresql/server/mb/pg_wchar.h
+%%SERVER%%include/postgresql/server/nodes/bitmapset.h
 %%SERVER%%include/postgresql/server/nodes/execnodes.h
 %%SERVER%%include/postgresql/server/nodes/makefuncs.h
 %%SERVER%%include/postgresql/server/nodes/memnodes.h
@@ -342,6 +400,7 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/port/aix.h
 %%SERVER%%include/postgresql/server/port/beos.h
 %%SERVER%%include/postgresql/server/port/bsdi.h
+%%SERVER%%include/postgresql/server/port/cygwin.h
 %%SERVER%%include/postgresql/server/port/darwin.h
 %%SERVER%%include/postgresql/server/port/dgux.h
 %%SERVER%%include/postgresql/server/port/freebsd.h
@@ -360,13 +419,11 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/port/ultrix4.h
 %%SERVER%%include/postgresql/server/port/univel.h
 %%SERVER%%include/postgresql/server/port/unixware.h
-%%SERVER%%include/postgresql/server/port/win.h
 %%SERVER%%include/postgresql/server/port/win32.h
-%%SERVER%%include/postgresql/server/regex/cclass.h
-%%SERVER%%include/postgresql/server/regex/cname.h
+%%SERVER%%include/postgresql/server/regex/regcustom.h
+%%SERVER%%include/postgresql/server/regex/regerrs.h
 %%SERVER%%include/postgresql/server/regex/regex.h
-%%SERVER%%include/postgresql/server/regex/regex2.h
-%%SERVER%%include/postgresql/server/regex/utils.h
+%%SERVER%%include/postgresql/server/regex/regguts.h
 %%SERVER%%include/postgresql/server/rewrite/prs2lock.h
 %%SERVER%%include/postgresql/server/rewrite/rewriteDefine.h
 %%SERVER%%include/postgresql/server/rewrite/rewriteHandler.h
@@ -392,7 +449,6 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/storage/lock.h
 %%SERVER%%include/postgresql/server/storage/lwlock.h
 %%SERVER%%include/postgresql/server/storage/off.h
-%%SERVER%%include/postgresql/server/storage/page.h
 %%SERVER%%include/postgresql/server/storage/pg_sema.h
 %%SERVER%%include/postgresql/server/storage/pg_shmem.h
 %%SERVER%%include/postgresql/server/storage/pmsignal.h
@@ -414,7 +470,6 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/utils/acl.h
 %%SERVER%%include/postgresql/server/utils/array.h
 %%SERVER%%include/postgresql/server/utils/ascii.h
-%%SERVER%%include/postgresql/server/utils/bit.h
 %%SERVER%%include/postgresql/server/utils/builtins.h
 %%SERVER%%include/postgresql/server/utils/cash.h
 %%SERVER%%include/postgresql/server/utils/catcache.h
@@ -424,13 +479,15 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/utils/dynahash.h
 %%SERVER%%include/postgresql/server/utils/dynamic_loader.h
 %%SERVER%%include/postgresql/server/utils/elog.h
-%%SERVER%%include/postgresql/server/utils/fcache.h
+%%SERVER%%include/postgresql/server/utils/errcodes.h
 %%SERVER%%include/postgresql/server/utils/fmgroids.h
 %%SERVER%%include/postgresql/server/utils/fmgrtab.h
 %%SERVER%%include/postgresql/server/utils/formatting.h
 %%SERVER%%include/postgresql/server/utils/geo_decls.h
 %%SERVER%%include/postgresql/server/utils/guc.h
+%%SERVER%%include/postgresql/server/utils/guc_tables.h
 %%SERVER%%include/postgresql/server/utils/hsearch.h
+%%SERVER%%include/postgresql/server/utils/help_config.h
 %%SERVER%%include/postgresql/server/utils/inet.h
 %%SERVER%%include/postgresql/server/utils/int8.h
 %%SERVER%%include/postgresql/server/utils/inval.h
@@ -454,15 +511,20 @@ share/postgresql/post-install-notes
 %%SERVER%%include/postgresql/server/utils/tqual.h
 %%SERVER%%include/postgresql/server/utils/tuplesort.h
 %%SERVER%%include/postgresql/server/utils/tuplestore.h
+%%SERVER%%include/postgresql/server/utils/typcache.h
 %%SERVER%%include/postgresql/server/utils/varbit.h
-%%SERVER%%include/postgresql/server/pg_config.h
-%%SERVER%%include/postgresql/server/pg_config_os.h
 %%SERVER%%include/postgresql/server/c.h
 %%SERVER%%include/postgresql/server/dynloader.h
 %%SERVER%%include/postgresql/server/fmgr.h
 %%SERVER%%include/postgresql/server/funcapi.h
+%%SERVER%%include/postgresql/server/getaddrinfo.h
+%%SERVER%%include/postgresql/server/getopt_long.h
 %%SERVER%%include/postgresql/server/miscadmin.h
+%%SERVER%%include/postgresql/server/pg_config.h
+%%SERVER%%include/postgresql/server/pg_config_manual.h
+%%SERVER%%include/postgresql/server/pg_config_os.h
 %%SERVER%%include/postgresql/server/pgstat.h
+%%SERVER%%include/postgresql/server/port.h
 %%SERVER%%include/postgresql/server/postgres.h
 %%SERVER%%include/postgresql/server/postgres_ext.h
 %%SERVER%%include/postgresql/server/postgres_fe.h