Maintainer update to PostgreSQL 7.4.1. This release includes fixed ident

authentication support for FreeBSD (been broken since 7.4).  Merry
Christmas to all, and to all a good night.

Release notes:
http://developer.postgresql.org/docs/postgres/release.html#RELEASE-7-4-1

Prompted by PR:	ports/60542
Obtained from:	maintainer

1 files changed, 16 insertions, 0 deletions

diff --git a/databases/postgresql-devel-server/files/pkg-message.server b/databases/postgresql-devel-server/files/pkg-message.server
index a2e7293462ca..69826681eb42 100644
--- a/databases/postgresql-devel-server/files/pkg-message.server
+++ b/databases/postgresql-devel-server/files/pkg-message.server
@@ -19,3 +19,19 @@ NB. FreeBSD's PostgreSQL port now by default logs to syslog
 
 For more tips, read ~pgsql/post-install-notes
 ======================================================================
+Specific for the 7.4.1 update:
+
+   A dump/restore is *not* required for those running 7.4.
+
+   If you want to install the fixes in the information schema you need to
+   reload it into the database. This is either accomplished by
+   initializing a new cluster by running "initdb", or by running the
+   following sequence of SQL commands in each database (ideally including
+   template1) as a superuser in psql, after installing the new release:
+DROP SCHEMA information_schema CASCADE;
+\i /usr/local/pgsql/share/information_schema.sql
+
+   Fixes to the information schema (from HISTORY):
+     * Fix information schema for bit data types (Peter)
+     * Fix information schema view constraint_column_usage for foreign
+       keys (Peter)