时间戳

首页 > 解决方案 > PostgreSQL Function Error: No function matches the given name and argument types. You might need to add explicit type casts

postgresql - PostgreSQL Function Error: No function matches the given name and argument types. You might need to add explicit type casts

问题描述

I am currently new to PostgreSQL and I am implementing pgrouting using Esri Shapefiles. The query I am writing is :

SELECT pgr_createTopology('point_file'::text,0.000001,'the_geom'::text, 'gid'::text);

"point_file" is the table name ,"the_geom" is the geometry column, and "gid" is the id column.

The error I am getting is :

ERROR: function pgr_createtopology(text, numeric,text, text) does not exist LINE 1: SELECT pgr_createTopology('point_file'::text,0.000001,'th...

HINT: No function matches the given name and argument types. You might need to add explicit type casts. SQL state: 42883 Character: 8

NOTE: I have already added postgis as an extension. I am using PostgreSQL 13 AND PostGIS 3.1.

标签： postgresqlfunctiongisshapefilepgrouting

解决方案

推荐阅读