Update postgresql74* packages to 7.4.8.

                                Release Notes

                                Release 7.4.8

     Release date: 2005-05-09

   This release contains a variety of fixes from 7.4.7, including several
   security-related issues.
     __________________________________________________________________

Migration to version 7.4.8

   A dump/restore is not required for those running 7.4.X. However, it is
   one possible way of handling two significant security problems that
   have been found in the initial contents of 7.4.X system catalogs. A
   dump/initdb/reload sequence using 7.4.8's initdb will automatically
   correct these problems.

   The larger security problem is that the built-in character set encoding
   conversion functions can be invoked from SQL commands by unprivileged
   users, but the functions were not designed for such use and are not
   secure against malicious choices of arguments. The fix involves
   changing the declared parameter list of these functions so that they
   can no longer be invoked from SQL commands. (This does not affect their
   normal use by the encoding conversion machinery.)

   The lesser problem is that the "contrib/tsearch2" module creates
   several functions that are misdeclared to return internal when they do
   not accept internal arguments. This breaks type safety for all
   functions using internal arguments.

   It is strongly recommended that all installations repair these errors,
   either by initdb or by following the manual repair procedures given
   below. The errors at least allow unprivileged database users to crash
   their server process, and may allow unprivileged users to gain the
   privileges of a database superuser.

While here, fix postgresql74-client package installation on 2.0
(broken -X), and avoid the need for gtar in tcl-postgresql74.

4 files changed, 122 insertions, 11 deletions

diff --git a/databases/postgresql74-client/Makefile b/databases/postgresql74-client/Makefile
index 186391aa77b..2cd7b177d81 100644
--- a/databases/postgresql74-client/Makefile
+++ b/databases/postgresql74-client/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.11 2005/05/16 01:32:22 jlam Exp $
+# $NetBSD: Makefile,v 1.12 2005/06/30 01:50:10 wiz Exp $
 
 PKGNAME=		postgresql74-client-${BASE_VERS}
 PKGREVISION=		# empty
@@ -24,8 +24,8 @@ pre-build:
 		../../src/include/parser/parse.h ../../src/include/utils/fmgroids.h
 
 post-install:
-	${EGREP} -v "^#" ${FILESDIR}/man.exclude > ${WRKDIR}/man_tar_exclude
-	${TAR} -zxm -C ${PREFIX}/man -X ${WRKDIR}/man_tar_exclude	\
+	${EGREP} -v "^#" ${FILESDIR}/man.client > ${WRKDIR}/man_tar_files
+	${TAR} -zxm -C ${PREFIX}/man -T ${WRKDIR}/man_tar_files	\
 		-f ${WRKSRC}/doc/man.tar.gz
 
 .include "../../mk/bsd.prefs.mk"
diff --git a/databases/postgresql74-client/PLIST b/databases/postgresql74-client/PLIST
index 9d59f4ce450..67d071275fc 100644
--- a/databases/postgresql74-client/PLIST
+++ b/databases/postgresql74-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2004/12/18 14:26:15 darcy Exp $
+@comment $NetBSD: PLIST,v 1.4 2005/06/30 01:50:10 wiz Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -182,6 +182,10 @@ ${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_dump.mo
 ${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pg_resetxlog.mo
 ${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/pgscripts.mo
 ${PKGLOCALEDIR}/locale/sv/LC_MESSAGES/psql.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_controldata.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pg_resetxlog.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/pgscripts.mo
+${PKGLOCALEDIR}/locale/tr/LC_MESSAGES/psql.mo
 ${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_controldata.mo
 ${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_dump.mo
 ${PKGLOCALEDIR}/locale/zh_CN/LC_MESSAGES/pg_resetxlog.mo
diff --git a/databases/postgresql74-client/files/man.client b/databases/postgresql74-client/files/man.client
new file mode 100644
index 00000000000..1d8ff49d342
--- /dev/null
+++ b/databases/postgresql74-client/files/man.client
@@ -0,0 +1,114 @@
+# $NetBSD: man.client,v 1.1 2005/06/30 01:50:10 wiz Exp $
+#
+man1/clusterdb.1
+man1/createdb.1
+man1/createlang.1
+man1/createuser.1
+man1/dropdb.1
+man1/droplang.1
+man1/dropuser.1
+man1/initdb.1
+man1/initlocation.1
+man1/ipcclean.1
+man1/pg_config.1
+man1/pg_controldata.1
+man1/pg_ctl.1
+man1/pg_dump.1
+man1/pg_dumpall.1
+man1/pg_resetxlog.1
+man1/pg_restore.1
+man1/psql.1
+man1/vacuumdb.1
+manl/abort.l
+manl/alter_aggregate.l
+manl/alter_conversion.l
+manl/alter_database.l
+manl/alter_domain.l
+manl/alter_function.l
+manl/alter_group.l
+manl/alter_language.l
+manl/alter_operator_class.l
+manl/alter_schema.l
+manl/alter_sequence.l
+manl/alter_table.l
+manl/alter_trigger.l
+manl/alter_user.l
+manl/analyze.l
+manl/begin.l
+manl/checkpoint.l
+manl/close.l
+manl/cluster.l
+manl/comment.l
+manl/commit.l
+manl/copy.l
+manl/create_aggregate.l
+manl/create_cast.l
+manl/create_constraint_trigger.l
+manl/create_conversion.l
+manl/create_database.l
+manl/create_domain.l
+manl/create_function.l
+manl/create_group.l
+manl/create_index.l
+manl/create_language.l
+manl/create_operator.l
+manl/create_operator_class.l
+manl/create_rule.l
+manl/create_schema.l
+manl/create_sequence.l
+manl/create_table.l
+manl/create_table_as.l
+manl/create_trigger.l
+manl/create_type.l
+manl/create_user.l
+manl/create_view.l
+manl/deallocate.l
+manl/declare.l
+manl/delete.l
+manl/drop_aggregate.l
+manl/drop_cast.l
+manl/drop_conversion.l
+manl/drop_database.l
+manl/drop_domain.l
+manl/drop_function.l
+manl/drop_group.l
+manl/drop_index.l
+manl/drop_language.l
+manl/drop_operator.l
+manl/drop_operator_class.l
+manl/drop_rule.l
+manl/drop_schema.l
+manl/drop_sequence.l
+manl/drop_table.l
+manl/drop_trigger.l
+manl/drop_type.l
+manl/drop_user.l
+manl/drop_view.l
+manl/end.l
+manl/execute.l
+manl/explain.l
+manl/fetch.l
+manl/grant.l
+manl/insert.l
+manl/listen.l
+manl/load.l
+manl/lock.l
+manl/move.l
+manl/notify.l
+manl/prepare.l
+manl/reindex.l
+manl/reset.l
+manl/revoke.l
+manl/rollback.l
+manl/select.l
+manl/select_into.l
+manl/set.l
+manl/set_constraints.l
+manl/set_session_authorization.l
+manl/set_transaction.l
+manl/show.l
+manl/start_transaction.l
+manl/truncate.l
+manl/unlisten.l
+manl/update.l
+manl/vacuum.l
diff --git a/databases/postgresql74-client/files/man.exclude b/databases/postgresql74-client/files/man.exclude
deleted file mode 100644
index f85ba8b2ec8..00000000000
--- a/databases/postgresql74-client/files/man.exclude
+++ /dev/null
@@ -1,7 +0,0 @@
-# $NetBSD: man.exclude,v 1.1.1.1 2004/04/19 00:03:25 recht Exp $
-#
-man1/ecpg.1
-man1/pgtclsh.1
-man1/pgtksh.1
-man1/postgres.1
-man1/postmaster.1