function pgr_pointsaspolygon(unknown) does not exist

Question

Im trying to run the query below in postgresql/postgis:

SELECT ST_AsText(pgr_pointsAsPolygon('SELECT id::int4, ST_X(geo)::float8 AS x, ST_Y(geo)::float8 as y FROM junction WHERE id IN ( 1050062040,.. ) UNION ALL SELECT 0::int4, 80.9475631713867::float8 as x, 26.8484115600586::float8 AS y  ')) ;

But getting following error:

ERROR:  function pgr_pointsaspolygon(unknown) does not exist
LINE 1: SELECT ST_AsText(pgr_pointsAsPolygon('SELECT id::int4, ST_X(...
                         ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Have installed postgis and have pgrouting extension also. Any help ?

Answer 1

As Dmitry Abt said, it seems that in pg_routing 3.0 it's no longer a function. Not sure what you're trying to do, and I never used this function, but maybe ST_ConcaveHull (or eventually ST_ConvexHull) could do the same job? Or you still have pgr_alphaShape in 3.0, wich seems to be the core function for alpha shapes.

Edit: as JGH said, the signature of the pgr_alphaShape changed, so I edited the link

Answer 2

I encountered the same problem - after installing the extension, I did not find this function. PgRouting version is 3.0.

> postgres=# SELECT pgr_version();  pgr_version 
> -------------
>  3.0.0-beta (1 row)

It can be seen that there really is no function.

postgres=# \df pgr_pointsAsPolygon
                       List of functions
 Schema | Name | Result data type | Argument data types | Type 
--------+------+------------------+---------------------+------
(0 rows)

It says here that this function is moved to legacy. And here about this function...

Maybe you should try installing a different version of the extension?