Ticket #87: routing_core_031207.patch
File routing_core_031207.patch, 1.3 KB (added by rodj59, 3 years ago) |
---|
-
usr/share/postgresql/routing_core.sql
old new 91 91 RETURNS void AS 92 92 $$ 93 93 BEGIN 94 EXECUTE 'SELECT create_graph_tables(' ''||quote_ident(geom_table)||''',''int4'',' || '''gid'' ,''source_id'',''target_id'')';94 EXECUTE 'SELECT create_graph_tables('||quote_literal(geom_table)||',''int4'',' || '''gid'' ,''source_id'',''target_id'')'; 95 95 END; 96 96 $$ 97 97 LANGUAGE 'plpgsql' VOLATILE STRICT; … … 101 101 RETURNS void AS 102 102 $$ 103 103 BEGIN 104 EXECUTE 'SELECT create_graph_tables(' ''||quote_ident(geom_table)||''','''||quote_ident(column_type)||''',' || '''gid'' ,''source_id'',''target_id'')';104 EXECUTE 'SELECT create_graph_tables('||quote_literal(geom_table)||','||quote_literal(column_type)||',' || '''gid'' ,''source_id'',''target_id'')'; 105 105 END; 106 106 $$ 107 107 LANGUAGE 'plpgsql' VOLATILE STRICT; … … 111 111 RETURNS void AS 112 112 $$ 113 113 BEGIN 114 EXECUTE 'SELECT create_graph_tables(' ''||quote_literal(geom_table)||''','''||quote_literal(column_type)||''',''' || quote_literal(id_name) || ''' ,''source_id'',''target_id'')';114 EXECUTE 'SELECT create_graph_tables('||quote_literal(geom_table)||','||quote_literal(column_type)||',' || quote_literal(id_name) || ' ,''source_id'',''target_id'')'; 115 115 RETURN; 116 116 END; 117 117 $$