[postgis-devel] Small bug in topology.AddToSearchPath

Jose Carlos Martinez Llario jomarlla at cgf.upv.es
Wed Dec 7 13:25:53 PST 2011


Hi List,
just a small bug found in topology.sql,

in the topology.AddToSearchPath function the current_database() variable 
should be used with quote_ident.

old:
EXECUTE 'ALTER DATABASE ' || current_database() || ' SET search_path = ' 
|| var_cur_search_path || ', ' || quote_ident(a_schema_name);

new:
EXECUTE 'ALTER DATABASE ' || quote_ident(current_database()) || ' SET 
search_path = ' || var_cur_search_path || ', ' || 
quote_ident(a_schema_name);

now its running with my database name.
best,
Jose




More information about the postgis-devel mailing list