From debb7da318f3158c283a54428dc3f015b0577d69 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 27 Nov 2005 10:52:30 +0000
Subject: - Patch #39019 by Cvbge: set search_path for functions in
 database.pgsql.

---
 database/database.pgsql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'database')

diff --git a/database/database.pgsql b/database/database.pgsql
index 1499e0bd6..c58b8c7e1 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -872,6 +872,9 @@ ALTER SEQUENCE menu_mid_seq RESTART 3;
 --- Functions
 ---
 
+--- Always installed in 'public' as prefix isn't appended to function names
+SET search_path TO public;
+
 CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric) RETURNS numeric AS '
   SELECT CASE WHEN (($1 > $2) OR ($2 IS NULL)) THEN $1 ELSE $2 END;
 ' LANGUAGE 'sql';
-- 
cgit v1.2.3