From 84141634edfd99c69b403afd0b7aaace77e09d91 Mon Sep 17 00:00:00 2001
From: rurban <rurban@96ab9672-09ca-45d6-a79d-3d69d39ca109>
Date: Sat, 23 Dec 2006 11:56:17 +0000
Subject: [PATCH] note about vacuum permissions

git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@5249 96ab9672-09ca-45d6-a79d-3d69d39ca109
---
 lib/WikiDB/backend/ADODB_postgres7.php |  6 ++++--
 lib/WikiDB/backend/PearDB_pgsql.php    | 10 ++++++++--
 2 files changed, 12 insertions(+), 4 deletions(-)

diff --git a/lib/WikiDB/backend/ADODB_postgres7.php b/lib/WikiDB/backend/ADODB_postgres7.php
index 48db63445..da87857c5 100644
--- a/lib/WikiDB/backend/ADODB_postgres7.php
+++ b/lib/WikiDB/backend/ADODB_postgres7.php
@@ -1,5 +1,5 @@
 <?php // -*-php-*-
-rcs_id('$Id: ADODB_postgres7.php,v 1.6 2006-12-03 16:25:20 rurban Exp $');
+rcs_id('$Id: ADODB_postgres7.php,v 1.7 2006-12-23 11:56:17 rurban Exp $');
 
 require_once('lib/WikiDB/backend/ADODB.php');
 
@@ -35,9 +35,11 @@ extends WikiDB_backend_ADODB
 
     /**
      * Pack tables.
+     * NOTE: Only the table owner can do this. Either fix the schema or setup autovacuum.
      */
     function optimize() {
-        return 0; // if the wikiuser is not the table owner
+        return 0; 	// if the wikiuser is not the table owner
+
         foreach ($this->_table_names as $table) {
             $this->_dbh->Execute("VACUUM ANALYZE $table");
         }
diff --git a/lib/WikiDB/backend/PearDB_pgsql.php b/lib/WikiDB/backend/PearDB_pgsql.php
index c3e9805a2..dac819fe6 100644
--- a/lib/WikiDB/backend/PearDB_pgsql.php
+++ b/lib/WikiDB/backend/PearDB_pgsql.php
@@ -1,5 +1,5 @@
 <?php // -*-php-*-
-rcs_id('$Id: PearDB_pgsql.php,v 1.24 2006-12-22 00:27:37 rurban Exp $');
+rcs_id('$Id: PearDB_pgsql.php,v 1.25 2006-12-23 11:56:17 rurban Exp $');
 
 require_once('lib/ErrorManager.php');
 require_once('lib/WikiDB/backend/PearDB.php');
@@ -44,9 +44,12 @@ extends WikiDB_backend_PearDB
     }
             
     /**
-     * Pack tables.
+     * Pack tables. 
+     * NOTE: Only the table owner can do this. Either fix the schema or setup autovacuum.
      */
     function optimize() {
+        return 0;	// if the wikiuser is not the table owner
+
         foreach ($this->_table_names as $table) {
             $this->_dbh->query("VACUUM ANALYZE $table");
         }
@@ -313,6 +316,9 @@ select * from stat('select idxfti from version') order by ndoc desc, nentry desc
 }
 
 // $Log: not supported by cvs2svn $
+// Revision 1.24  2006/12/22 00:27:37  rurban
+// just add Log
+//
 
 // (c-file-style: "gnu")
 // Local Variables:
-- 
2.45.0