[pgrouting-users] postgis 2.0 and postgresql 9.1
Pedro Costa
pedrocostaarma at sapo.pt
Wed Jun 6 13:41:02 PDT 2012
Hi Daniel,
I don't know how to fix that but if anybody have an idea i can spent
some time trying...
any tips on how to solve the problem?
I created a new ticket:
https://github.com/pgRouting/pgrouting/issues/58
thanks
Em 06-06-2012 20:19, Daniel Kastl escreveu:
> Hi Pedro,
>
> If you were able to fix assign_vertex_id function for PostGIS 2.0,
> adding a ticket to the GitHub issue tracker [1] would be nice ... and
> even better with some patch.
>
> Daniel
>
> [1] https://github.com/pgrouting/pgrouting/issues?state=open
>
>
> On Wed, Jun 6, 2012 at 8:00 PM, Stephen Woodbridge
> <woodbri at swoodbridge.com <mailto:woodbri at swoodbridge.com>> wrote:
>
> On 6/6/2012 12:53 PM, Pedro Costa wrote:
>
> I'm trying now with postgis 2.0 and successfully create the
> templatefor
> routing based on postgis template 2.0.
>
> The problem I found is the function assign_vertex that gives the
> following error:
>
>
> NOTICE: CREATE TABLE will create implicit sequence
> "vertices_tmp_id_seq"
> for serial column "vertices_tmp.id <http://vertices_tmp.id>"
> CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id serial)"
> PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement
>
>
> ERROR: find_srid() - couldnt find the corresponding SRID - is the
> geometry registered in the GEOMETRY_COLUMNS table? Is there an
> uppercase/lowercase missmatch?
>
>
> In postgis 2.0 we do not have table geometry_columns, anybody
> know how
> to solve this problem?
>
>
> select Populate_Geometry_Columns();
>
> should fix this.
>
> -Steve
>
> Thanks
>
> Pedro
>
>
>
> Em 05-06-2012 03:40, Sanak escreveu:
>
> Hi Ricardo,
> I don't know all of the windows binaries, but I have not
> build 64bit
> one yet.
> PostGIS team have already supported windows mingw-64bit build,
> http://postgis.refractions.net/pipermail/postgis-users/2012-April/033745.html
> http://www.postgis.org/download/windows/#postgis-installers
> and began to make more crossplatform build system.(I guess
> this means
> move to cmake/msvc in windows).
> http://blog.opengeo.org/2012/05/17/postgis-code-sprint-recap/
> So, if the demand for windows 64bit binary seems to be large,
> I will begin to investigate about it on my
> git(https://github.com/sanak/pgrouting)
> mingw/msvc branch.
> Regards,
> 2012/6/4 Ricardo Bayley <ricardo.bayley at gmail.com
> <mailto:ricardo.bayley at gmail.com>
> <mailto:ricardo.bayley at gmail.com
> <mailto:ricardo.bayley at gmail.com>>>
>
>
> Is there a build for postgis under windows in a 64bit
> enviroment ?
>
> thanks
>
> 2012/5/23 Pedro Costa <pedrocostaarma at sapo.pt
> <mailto:pedrocostaarma at sapo.pt>
> <mailto:pedrocostaarma at sapo.pt
> <mailto:pedrocostaarma at sapo.pt>>>
>
>
>
> Hello James,
>
> Of course. I have win7 64 bits with postgresql
> 9.1.2 and
> postgis 1.5.3. I'm only copy the binaries [1] to
> the C path.
> Now I will try with postgis 2.0 and return the results.
>
> Thanks
>
> [1] https://github.com/sanak/pgrouting/downloads
>
>
>
> Em 23-05-2012 11:18, James David Smith escreveu:
>
> Hi Pedro,
>
> Would be very grateful if you'd provide a short
> summary of
> what you
> did to get it all working - along with links to the
> download packages?
>
> Thanks
>
> James
>
>
>
>
> On 23 May 2012 11:13, Pedro
> Costa<pedrocostaarma at sapo.pt <mailto:pedrocostaarma at sapo.pt>
> <mailto:pedrocostaarma at sapo.pt
> <mailto:pedrocostaarma at sapo.pt>>> wrote:
>
> Perfect....works....
>
> Thanks
>
>
>
> Em 22-05-2012 23:42, Sanak escreveu:
>
> Hi Pedro,
> If you use pgRouting on Windows, download
> module from
>
> here(https://github.com/sanak/pgrouting/downloads -
>
> pgRouting-git-sanak-mingw_20120310_pg-9.1(x86).zip).
> Because above module was based on git master
>
> branch(https://github.com/pgRouting/pgrouting) after
> justjkk's latest
> commit(2011/08/08), some drnextgis's sql
> fixes had
> already applied after
> release 1.0.5,
> but more drnextgis's
>
> fix(https://github.com/pgRouting/pgrouting/pull/50) may
> be necessary.
>
>
> Hi Jorge,
>
> Thanks for your report about PostgreSQL version
> incompatibility.
> I will check about this problem.
>
>
> Sorry for my english.
>
> Regards,
>
> 2012/5/23 Jorge
> Fuentes<jfuentes at estudiantes.uci.cu
> <mailto:jfuentes at estudiantes.uci.cu>
> <mailto:jfuentes at estudiantes.uci.cu
> <mailto:jfuentes at estudiantes.uci.cu>>>
>
>
> Was just easy like double clik and next
> next...
> but a had to download binaries from (I
> don't remember)
> .. but I'm sure that you will find that
> url in
> older post or googlering
> it..
> and be sure that you had postgreSQL
> 9.1.3 32 bit
> because i try with 9.1.1
> and not work because a dll change from that
> version to 9.1.3
> remember to execute .slq file from
> pgrouting
> best regards
>
>
> El 22/05/2012 12:35 pm, Pedro Costa
> escribió:
>
> Em 22-05-2012 16:48, Jorge Fuentes
> escreveu:
>
> Yes I had them install and running
> PosgreSQL 9.1.3, postGIS 2.0 and
> pgrouting on win 7-32bits
>
>
>
> Hi Jorge,
>
> It was necessary to any change in
> code? Or
> were the normal procedures?
>
> Thanks
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> <mailto:Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>>
>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
> 10mo. ANIVERSARIO DE LA CREACION DE LA
> UNIVERSIDAD DE LAS CIENCIAS
> INFORMATICAS...
> CONECTADOS AL FUTURO, CONECTADOS A
> LA REVOLUCION
>
> http://www.uci.cu
> http://www.facebook.com/universidad.uci
> http://www.flickr.com/photos/universidad_uci
>
>
>
> 10mo. ANIVERSARIO DE LA CREACION DE LA
> UNIVERSIDAD
> DE LAS CIENCIAS
> INFORMATICAS...
> CONECTADOS AL FUTURO, CONECTADOS A LA
> REVOLUCION
>
> http://www.uci.cu
> http://www.facebook.com/universidad.uci
> http://www.flickr.com/photos/universidad_uci
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> <mailto:Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>>
>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> <mailto:Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>>
>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> <mailto:Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>>
>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> <mailto:Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>>
>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> <mailto:Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>>
>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> <mailto:Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>>
>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> <mailto:Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> <mailto:Pgrouting-users at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de <mailto:daniel.kastl at georepublic.de>
> Web: http://georepublic.de <http://georepublic.de/>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120606/795dc066/attachment-0001.html>
More information about the Pgrouting-users
mailing list