postgres7: fix system warning in MetaColumns() with schema

When calling MetaColumns with schema.table, the driver triggers a
'Warning: sprintf(): Too few arguments' because the metaColumnsSQL1
statement contains one more parameter in 7 compared to the 6.4 version.

Resolved by adding a new protected _generateMetaColumnsSQL() method to
handle the preparation of the appropriate SQL statement, and overriding
it in the postgres7 driver.

http://phplens.com/lens/lensforum/msgs.php?id=19481

1 files changed, 17 insertions, 1 deletions

diff --git a/drivers/adodb-postgres7.inc.php b/drivers/adodb-postgres7.inc.php
index 6cb7226f..6efc599b 100644
--- a/drivers/adodb-postgres7.inc.php
+++ b/drivers/adodb-postgres7.inc.php
@@ -126,7 +126,23 @@ class ADODB_postgres7 extends ADODB_postgres64 {
 		}
 		return $sql;
 	}
- 	*/
+	*/
+
+	/**
+	 * Generate the SQL to retrieve MetaColumns data
+	 * @param string $table Table name
+	 * @param string $schema Schema name (can be blank)
+	 * @return string SQL statement to execute
+	 */
+	protected function _generateMetaColumnsSQL($table, $schema)
+	{
+		if ($schema) {
+			return sprintf($this->metaColumnsSQL1, $table, $table, $table, $schema);
+		}
+		else {
+			return sprintf($this->metaColumnsSQL, $table, $table, $schema);
+		}
+	}
 
 	/**
 	 * @returns assoc array where keys are tables, and values are foreign keys