From owner-freebsd-ports-bugs@FreeBSD.ORG  Sat May 13 16:30:30 2006
Return-Path: <owner-freebsd-ports-bugs@FreeBSD.ORG>
X-Original-To: freebsd-ports-bugs@hub.freebsd.org
Delivered-To: freebsd-ports-bugs@hub.freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id C804A16A6D7
	for <freebsd-ports-bugs@hub.freebsd.org>;
	Sat, 13 May 2006 16:30:30 +0000 (UTC)
	(envelope-from gnats@FreeBSD.org)
Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21])
	by mx1.FreeBSD.org (Postfix) with ESMTP id DFDE843D9D
	for <freebsd-ports-bugs@hub.freebsd.org>;
	Sat, 13 May 2006 16:30:17 +0000 (GMT)
	(envelope-from gnats@FreeBSD.org)
Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1])
	by freefall.freebsd.org (8.13.4/8.13.4) with ESMTP id k4DGUHZX094644
	for <freebsd-ports-bugs@freefall.freebsd.org>;
	Sat, 13 May 2006 16:30:17 GMT
	(envelope-from gnats@freefall.freebsd.org)
Received: (from gnats@localhost)
	by freefall.freebsd.org (8.13.4/8.13.4/Submit) id k4DGUHAu094643;
	Sat, 13 May 2006 16:30:17 GMT (envelope-from gnats)
Resent-Date: Sat, 13 May 2006 16:30:17 GMT
Resent-Message-Id: <200605131630.k4DGUHAu094643@freefall.freebsd.org>
Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer)
Resent-To: freebsd-ports-bugs@FreeBSD.org
Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org,
	Larry Rosenman <ler@lerctr.org>
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 1B4C316A676
	for <FreeBSD-gnats-submit@freebsd.org>;
	Sat, 13 May 2006 16:27:20 +0000 (UTC) (envelope-from ler@lerctr.org)
Received: from thebighonker.lerctr.org (thebighonker.lerctr.org
	[192.147.25.65])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 97FA543D5A
	for <FreeBSD-gnats-submit@freebsd.org>;
	Sat, 13 May 2006 16:27:17 +0000 (GMT) (envelope-from ler@lerctr.org)
Received: from ler by thebighonker.lerctr.org with local (Exim 4.62 (FreeBSD))
	(envelope-from <ler@lerctr.org>) id 1FewxZ-0001FE-25
	for FreeBSD-gnats-submit@freebsd.org; Sat, 13 May 2006 11:27:17 -0500
Message-Id: <E1FewxZ-0001FE-25@thebighonker.lerctr.org>
Date: Sat, 13 May 2006 11:27:17 -0500
From: Larry Rosenman <ler@lerctr.org>
To: FreeBSD-gnats-submit@FreeBSD.org
X-Send-Pr-Version: 3.113
Cc: 
Subject: ports/97206: [maintainer]] make mail/exilog more PostgreSQL friendly
X-BeenThere: freebsd-ports-bugs@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: Larry Rosenman <ler@lerctr.org>
List-Id: Ports bug reports <freebsd-ports-bugs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports-bugs>, 
	<mailto:freebsd-ports-bugs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports-bugs>
List-Post: <mailto:freebsd-ports-bugs@freebsd.org>
List-Help: <mailto:freebsd-ports-bugs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports-bugs>, 
	<mailto:freebsd-ports-bugs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 13 May 2006 16:30:40 -0000


>Number:         97206
>Category:       ports
>Synopsis:       [maintainer]] make mail/exilog more PostgreSQL friendly
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          maintainer-update
>Submitter-Id:   current-users
>Arrival-Date:   Sat May 13 16:30:17 GMT 2006
>Closed-Date:
>Last-Modified:
>Originator:     Larry Rosenman
>Release:        FreeBSD 6.1-STABLE amd64
>Organization:
LERCTR Consulting
>Environment:
System: FreeBSD thebighonker.lerctr.org 6.1-STABLE FreeBSD 6.1-STABLE #54: Sat May 13 10:21:24 CDT 2006 root@thebighonker.lerctr.org:/usr/obj/usr/src/sys/THEBIGHONKER amd64


>Description:
PostgreSQL doesn't have an "OPTIMIZE TABLE" command, so we replace
that with "VACUUM ANALYZE" which does roughly the same thing.
>How-To-Repeat:
>Fix:
place the following in ports/mail/exilog/files/patch-exilog_sql.pm
--- /usr/local/www/exilog/exilog_sql.pm	Tue Feb 21 16:23:56 2006
+++ exilog_sql.pm	Wed Aug 24 09:22:29 2005
@@ -208,7 +208,7 @@
 sub _pgsql_sql_optimize {
   my $where = shift || "nothing";
 
-  my $sql = "OPTIMIZE TABLE ".$where;
+  my $sql = "VACUUM ANALYZE  ".$where;
   my $sh = $dbh->prepare($sql);
   $sh->execute;
   $sh->finish;

>Release-Note:
>Audit-Trail:
>Unformatted: