[pgrouting-users] Error updating to PgRouting 2.1.0 (Pg 9.3.9, 32bit)

McDonaldR McDonaldR at angus.gov.uk
Wed Aug 12 02:24:03 PDT 2015

Hello list,

I get an error message when trying to update pgRouting from 2.0.0 to 2.1.0 in a Postgresql 9.3.9 32bit database on Windows 7.

ALTER EXTENSION pgrouting UPDATE TO "2.1.0";

ERROR: function pgr_alphashape(text) does not exist
SQL state: 42883

I am using this build of pgRouting - http://winnie.postgis.net/download/windows/pg93/buildbot/pgrouting-pg93-binaries-2.1.0-betaw32gcc481.zip

Currently installed version is:

Was hoping to get:
2.1.0, pgrouting-2.1.0-alpha1, 81, 5fa89b2, develop_2_1_0, 1.58.0

For some context, the pgr_alphashape function currently installed in my database is:

-- Function: public.pgr_alphashape(text, double precision)
-- DROP FUNCTION public.pgr_alphashape(text, double precision);
CREATE OR REPLACE FUNCTION public.pgr_alphashape(IN sql text, IN alpha double precision DEFAULT 0, OUT x double precision, OUT y double precision)
'$libdir/librouting_dd', 'alphashape'
  COST 1
  ROWS 1000;

The new alphashape function to be created looks like this:

CREATE OR REPLACE FUNCTION pgr_alphashape(sql text, alpha float8 DEFAULT 0, OUT x float8, OUT y float8)
    RETURNS SETOF record
    AS '$libdir/librouting-2.1', 'alphashape'

Is it best to post these here or should I use Github issues?


Ross McDonald | GIS Data Coordinator | Resources Department, IT Division | Angus Council, Angus House, Orchardbank Business Park, Forfar, DD8 1AT
T: 01307 476419 | F: 01307 476401 | E: mcdonaldr at angus.gov.uk<mailto:mcdonaldr at angus.gov.uk>

This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20150812/f71db597/attachment.html>

More information about the Pgrouting-users mailing list