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

[McDonaldR]

Regina,

You're quite right - I had 2.0 and not 2.0.0 installed.

Reinstalled on a clean database and got the version correct (2.0.0) and updated to pgrouting 2.1.0 without a problem.

Thanks

Ross

From: pgrouting-users-bounces at lists.osgeo.org [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Paragon Corporation
Sent: 12 August 2015 13:46
To: 'pgRouting users mailing list'
Subject: Re: [pgrouting-users] Error updating to PgRouting 2.1.0 (Pg 9.3.9, 32bit)

Ross,

This might be just a windows packaging issue or you picked up an interim 2.0 when you installed.

I had this issue once, and I think the problem is you were maybe running 2.0 develop which shows as 2.0.0, but really isn't 2.0.0.  It's somewhere between 2.0.0 and 2.1.0

You can tell because the actual released version have branch master or tag like this:

2.0.0;pgrouting-2.0.0;0;f26831f;master;1.53.0


Anyway you say you are testing with 9.3 32-bit. I'll look into that to make sure I didn't mispackage the 2.0.0 on the 9.3 32-bit.

If I didn't then its just you installed the 2.0 package instead of the 2.0.0 package originally.

I don't think any tables actually depend on pgRouting so if you don't have any SQL functions built on it,  it's safe to just delete pgrouting extension and reinstall it.

Plpgsql are opaque anyway so the use of pgRouting in them will not force them to drop when you drop the pgRouting extension.


Thanks,
Regina


From: pgrouting-users-bounces at lists.osgeo.org<mailto:pgrouting-users-bounces at lists.osgeo.org> [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of McDonaldR
Sent: Wednesday, August 12, 2015 5:24 AM
To: pgrouting-users at lists.osgeo.org<mailto:pgrouting-users at lists.osgeo.org>
Subject: [pgrouting-users] Error updating to PgRouting 2.1.0 (Pg 9.3.9, 32bit)

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:
"2.0.0";"pgrouting-2.0.0";"40";"567ac3b";"develop";"1.53.0"

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)
  RETURNS SETOF record AS
'$libdir/librouting_dd', 'alphashape'
  LANGUAGE c IMMUTABLE STRICT
  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'
    LANGUAGE c IMMUTABLE STRICT;

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


Ross


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.

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/3fae8e72/attachment.html>