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@lists.osgeo.org] On Behalf Of pgrouting-users-request@lists.osgeo.org
Sent: Friday, April 22, 2016 3:00 PM
To: pgrouting-users@lists.osgeo.org
Subject: Pgrouting-users Digest, Vol 91, Issue 11
Send Pgrouting-users mailing list submissions to
pgrouting-users@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@lists.osgeo.org
You can reach the person managing the list at
pgrouting-users-owner@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@maine.gov>
To: "pgrouting-users@lists.osgeo.org"
<pgrouting-users@lists.osgeo.org>
Subject: [pgrouting-users] pgr_analyzeGraph syntax error
Message-ID:
<D655A37D8BC306438F87579A672E3D107FE0148F@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@georepublic.de>
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] pgr_analyzeGraph syntax error
Message-ID:
<CAK_FzuUj1wLFF8mPaja6Lp_3OUzFcfG7L9CF8n-ewf0QSCzS+g@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@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users
------------------------------
End of Pgrouting-users Digest, Vol 91, Issue 11
***********************************************