From f368926a88078051727f6f326cffa0edbcd34faa Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 5 Mar 2016 06:01:03 +0000 Subject: [PATCH] remove this hard-coded script superceded by perl generation script of #3490 References #2485 git-svn-id: http://svn.osgeo.org/postgis/trunk@14751 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/postgis_functions_search_path.sql | 44 ----------------------- 1 file changed, 44 deletions(-) delete mode 100644 postgis/postgis_functions_search_path.sql diff --git a/postgis/postgis_functions_search_path.sql b/postgis/postgis_functions_search_path.sql deleted file mode 100644 index 15cf4c952..000000000 --- a/postgis/postgis_functions_search_path.sql +++ /dev/null @@ -1,44 +0,0 @@ --- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --- --- --- PostGIS - Spatial Types for PostgreSQL --- http://postgis.net --- Copyright 2016 Regina Obe --- --- This is free software; you can redistribute and/or modify it under --- the terms of the GNU General Public Licence. See the COPYING file. --- --- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --- This routine adds search_path to functions known to have issues --- during restore. Functions that call other postgis functions --- or spatial_ref_sys should be in here --- These are functions that are called by restore process for purposes of --- creating indexes, creating constraints, and creating materialized views --- Also functions that are used in foreign tables --- that call other postgis functions. Eventually all functions should be here --- At that point we decide to add to all functions, --- this script should be autogenerated --- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -DO language plpgsql -$$ -DECLARE param_postgis_schema text; -BEGIN --- check if PostGIS is already installed -param_postgis_schema = (SELECT n.nspname from pg_extension e join pg_namespace n on e.extnamespace = n.oid WHERE extname = 'postgis'); - --- if in middle install, it will be the current_schema or what was there already -param_postgis_schema = COALESCE(param_postgis_schema, current_schema()); -EXECUTE 'set search_path TO ' || quote_ident(param_postgis_schema); - --- PostGIS geometry funcs -EXECUTE 'ALTER FUNCTION st_transform(geometry, integer) SET search_path=' || quote_ident(param_postgis_schema) || ';'; - --- PostGIS raster funcs -EXECUTE 'ALTER FUNCTION _raster_constraint_nodata_values(raster) SET search_path=' || quote_ident(param_postgis_schema) || ';'; -EXECUTE 'ALTER FUNCTION _raster_constraint_out_db(raster) SET search_path=' || quote_ident(param_postgis_schema) || ';'; -EXECUTE 'ALTER FUNCTION _raster_constraint_pixel_types(raster) SET search_path=' || quote_ident(param_postgis_schema) || ';'; -END; -$$ -- 2.40.0