From 8c780265a5b168c644cf96b0ca0e00e4133d967f Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Thu, 8 Dec 2011 08:07:58 +0000 Subject: [PATCH] topology.AddToSearchPath: quote database identifier. Thanks to Jose Carlos Martinez Llario git-svn-id: http://svn.osgeo.org/postgis/trunk@8315 b70326c6-7e19-0410-871a-916f4a2858ee --- topology/sql/manage/ManageHelper.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/topology/sql/manage/ManageHelper.sql b/topology/sql/manage/ManageHelper.sql index e1612ee7d..39150df77 100644 --- a/topology/sql/manage/ManageHelper.sql +++ b/topology/sql/manage/ManageHelper.sql @@ -29,7 +29,7 @@ BEGIN IF var_cur_search_path LIKE '%' || quote_ident(a_schema_name) || '%' THEN var_result := a_schema_name || ' already in database search_path'; ELSE - EXECUTE 'ALTER DATABASE ' || current_database() || ' SET search_path = ' || var_cur_search_path || ', ' || quote_ident(a_schema_name); + EXECUTE 'ALTER DATABASE ' || quote_ident(current_database()) || ' SET search_path = ' || var_cur_search_path || ', ' || quote_ident(a_schema_name); var_result := a_schema_name || ' has been added to end of database search_path '; END IF; -- 2.40.0