# HG changeset patch
# User Dan Fuhry <dan@enanocms.org>
# Date 1293647038 18000
# Node ID c7d6317c5e82dfcbaeb0cc2d5913b6075dd632be
# Parent  1649f687e69eefe2dec5621bec86d95a44676ccf
Fixed a postgresql bug in the File namespace (reported by phirox - thanks)

diff -r 1649f687e69e -r c7d6317c5e82 includes/namespaces/file.php
--- a/includes/namespaces/file.php	Wed Dec 29 13:22:39 2010 -0500
+++ b/includes/namespaces/file.php	Wed Dec 29 13:23:58 2010 -0500
@@ -189,10 +189,11 @@
 		}
 		$db->free_result();
 		$html .= '<h3>' . $lang->get('onpage_filebox_lbl_pagesusing') . '</h3>';
+		$regexp = ENANO_DBLAYER == 'PGSQL' ? '~ E' : 'REGEXP ';
 		$q = $db->sql_query('SELECT t.page_id, t.namespace, p.name FROM ' . table_prefix . "page_text AS t\n"
 			              . "  LEFT JOIN " . table_prefix . "pages AS p\n"
 			              . "    ON ( t.page_id = p.urlname AND t.namespace = p.namespace )\n"
-			              . "  WHERE t.page_text REGEXP '\\\\[\\\\[:" .
+			              . "  WHERE t.page_text {$regexp}'\\\\[\\\\[:" .
 							  addslashes(preg_quote($paths->nslist[$this->namespace])) .
 							  addslashes(preg_quote($this->page_id)) .
 							  "(\\\\||\\\\])';");