[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