From ed1450d04753d66c3e48f176fa97bc43a90b48c5 Mon Sep 17 00:00:00 2001
From: xzilla <xzilla>
Date: Mon, 25 Jul 2005 21:41:46 +0000
Subject: [PATCH] fix bug on 7.3 servers where listing schemas was completely
 broke.  Required show system objects off and $slony to be set. There are
 other issues here, but this fixes my problem :-)

---
 classes/database/Postgres73.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/classes/database/Postgres73.php b/classes/database/Postgres73.php
index 026cdea0..db76c892 100644
--- a/classes/database/Postgres73.php
+++ b/classes/database/Postgres73.php
@@ -4,7 +4,7 @@
  * A class that implements the DB interface for Postgres
  * Note: This class uses ADODB and returns RecordSets.
  *
- * $Id: Postgres73.php,v 1.146 2005/06/28 15:26:30 chriskl Exp $
+ * $Id: Postgres73.php,v 1.147 2005/07/25 21:41:46 xzilla Exp $
  */
 
 // @@@ THOUGHT: What about inherits? ie. use of ONLY???
@@ -123,7 +123,7 @@ class Postgres73 extends Postgres72 {
 			if (isset($slony)) {
 				$temp = $slony->slony_schema;
 				$this->clean($temp);
-				$and .= " AND npsname != '{$temp}'";
+				$and .= " AND nspname != '{$temp}'";
 			}
 		}
 		else $and = "AND nspname !~ '^pg_t(emp_[0-9]+|oast)$'";
@@ -135,6 +135,7 @@ class Postgres73 extends Postgres72 {
 		return $this->selectSet($sql);
 	}
 
+
 	/**
 	 * Return all information relating to a schema
 	 * @param $schema The name of the schema
-- 
2.39.5