[pgrouting-users] Pgrouting-users Digest, Vol 91, Issue 11

[Bistrais, Bob]

Yes, it was that simple- I forgot to put the Select statement at the beginning.  Thanks Vicky.



-----Original Message-----
From: Pgrouting-users [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of pgrouting-users-request at lists.osgeo.org
Sent: Friday, April 22, 2016 3:00 PM
To: pgrouting-users at lists.osgeo.org
Subject: Pgrouting-users Digest, Vol 91, Issue 11

Send Pgrouting-users mailing list submissions to
	pgrouting-users at lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.osgeo.org/mailman/listinfo/pgrouting-users
or, via email, send a message with subject or body 'help' to
	pgrouting-users-request at lists.osgeo.org

You can reach the person managing the list at
	pgrouting-users-owner at lists.osgeo.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of Pgrouting-users digest..."


Today's Topics:

   1. pgr_analyzeGraph syntax error (Bistrais, Bob)
   2. Re: pgr_analyzeGraph syntax error (Vicky Vergara)


----------------------------------------------------------------------

Message: 1
Date: Fri, 22 Apr 2016 15:00:47 +0000
From: "Bistrais, Bob" <Bob.Bistrais at maine.gov>
To: "pgrouting-users at lists.osgeo.org"
	<pgrouting-users at lists.osgeo.org>
Subject: [pgrouting-users] pgr_analyzeGraph syntax error
Message-ID:
	<D655A37D8BC306438F87579A672E3D107FE0148F at OIT-TEAQEXMBX01.som.w2k.state.me.us>
	
Content-Type: text/plain; charset="utf-8"

I am building topology on a road dataset with pg_routing.  When I try the analyzeGraph function, I get an error.  Here is the input:
pgr_analyzeGraph('ng_roads',1.0,the_geom:='geom_linestring',id:='ogc_fid',source:='sourceroute',target:='targetroute');

And here is the error message:
ERROR: syntax error at or near "pgr_analyzeGraph"
SQL state: 42601
Character: 316

Before that, pgr_createToology worked OK.

Postgis 2.1.5 and pgroutiung 2.1.0 are installed, Postgres9.3 database.

Any suggestions?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160422/10750a11/attachment-0001.html>

------------------------------

Message: 2
Date: Fri, 22 Apr 2016 11:09:34 -0500
From: Vicky Vergara <vicky at georepublic.de>
To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
Subject: Re: [pgrouting-users] pgr_analyzeGraph syntax error
Message-ID:
	<CAK_FzuUj1wLFF8mPaja6Lp_3OUzFcfG7L9CF8n-ewf0QSCzS+g at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

That looks like an error from postgresql query parser.
So I am parsing in my mind:
I dont see:
SELECT * FROM

Vicky

On Fri, Apr 22, 2016 at 10:00 AM, Bistrais, Bob <Bob.Bistrais at maine.gov>
wrote:

> I am building topology on a road dataset with pg_routing.  When I try 
> the analyzeGraph function, I get an error.  Here is the input:
>
>
> pgr_analyzeGraph('ng_roads',1.0,the_geom:='geom_linestring',id:='ogc_f
> id',source:='sourceroute',target:='targetroute');
>
>
>
> And here is the error message:
>
> ERROR: syntax error at or near "pgr_analyzeGraph"
>
> SQL state: 42601
>
> Character: 316
>
>
>
> Before that, pgr_createToology worked OK.
>
>
>
> Postgis 2.1.5 and pgroutiung 2.1.0 are installed, Postgres9.3 database.
>
>
>
> Any suggestions?
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>



-- 

Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44,
81739 München, Germany

Vicky Vergara
Operations Research

eMail: vicky at georepublic.de
Web: https://georepublic.info

Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9

Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20160422/2b4afd4e/attachment-0001.html>

------------------------------

Subject: Digest Footer

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

------------------------------

End of Pgrouting-users Digest, Vol 91, Issue 11
***********************************************