<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Century Gothic";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Century Gothic";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Ross,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>This might be just a windows packaging issue or you picked up an interim 2.0 when you installed.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>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<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>You can tell because the actual released version have branch master or tag like this:<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>2.0.0;pgrouting-2.0.0;0;f26831f;master;1.53.0<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>If I didn't then its just you installed the 2.0 package instead of the 2.0.0 package originally.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>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.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Plpgsql are opaque anyway so the use of pgRouting in them will not force them to drop when you drop the pgRouting extension.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:.5in'><b>From:</b> pgrouting-users-bounces@lists.osgeo.org [mailto:pgrouting-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>McDonaldR<br><b>Sent:</b> Wednesday, August 12, 2015 5:24 AM<br><b>To:</b> pgrouting-users@lists.osgeo.org<br><b>Subject:</b> [pgrouting-users] Error updating to PgRouting 2.1.0 (Pg 9.3.9, 32bit)<o:p></o:p></p></div></div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>Hello list,<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>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.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>ALTER EXTENSION pgrouting UPDATE TO "2.1.0";<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>ERROR: function pgr_alphashape(text) does not exist<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>SQL state: 42883<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>I am using this build of pgRouting - <a href="http://winnie.postgis.net/download/windows/pg93/buildbot/pgrouting-pg93-binaries-2.1.0-betaw32gcc481.zip">http://winnie.postgis.net/download/windows/pg93/buildbot/pgrouting-pg93-binaries-2.1.0-betaw32gcc481.zip</a><o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>Currently installed version is:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>"2.0.0";"pgrouting-2.0.0";"40";"567ac3b";"develop";"1.53.0"<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>Was hoping to get:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>2.1.0, pgrouting-2.1.0-alpha1, 81, 5fa89b2, develop_2_1_0, 1.58.0<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>For some context, the pgr_alphashape function currently installed in my database is:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>-- Function: public.pgr_alphashape(text, double precision)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>-- DROP FUNCTION public.pgr_alphashape(text, double precision);<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>CREATE OR REPLACE FUNCTION public.pgr_alphashape(IN sql text, IN alpha double precision DEFAULT 0, OUT x double precision, OUT y double precision)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'> RETURNS SETOF record AS<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>'$libdir/librouting_dd', 'alphashape'<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'> LANGUAGE c IMMUTABLE STRICT<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'> COST 1<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'> ROWS 1000;<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>The new alphashape function to be created looks like this:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>CREATE OR REPLACE FUNCTION pgr_alphashape(sql text, alpha float8 DEFAULT 0, OUT x float8, OUT y float8)<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'> RETURNS SETOF record<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'> AS '$libdir/librouting-2.1', 'alphashape'<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'> LANGUAGE c IMMUTABLE STRICT;<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>Is it best to post these here or should I use Github issues?<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'>Ross<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><b><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic";color:#4F6228;mso-fareast-language:EN-GB'>Ross McDonald </span></b><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic";color:#4F6228;mso-fareast-language:EN-GB'>|<b> </b>GIS Data Coordinator | Resources Department, IT Division | Angus Council, Angus House, Orchardbank Business Park, Forfar, DD8 1AT<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic";color:#4F6228;mso-fareast-language:EN-GB'>T: <b>01307 476419</b> | F: 01307 476401 | E: <a href="mailto:mcdonaldr@angus.gov.uk"><span style='color:#4F6228'>mcdonaldr@angus.gov.uk</span></a> <b><o:p></o:p></b></span></p><p class=MsoNormal align=center style='margin-left:.5in;text-align:center'><span lang=EN-GB style='font-size:13.0pt;font-family:"Century Gothic";color:#4F6228;mso-fareast-language:EN-GB'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB><o:p> </o:p></span></p><div><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:12.0pt;font-family:"Times New Roman",serif'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-left:.5in'><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial",sans-serif'>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. </span><span lang=EN-GB><o:p></o:p></span></p></div></div></body></html>