[pgrouting-users] postgis 2.0 and postgresql 9.1
Pedro Costa
pedrocostaarma at sapo.pt
Wed Jun 6 09:53:02 PDT 2012
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"
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?
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>>
>
> 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>>
>
>
> 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>> 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>>
>
> 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>
> 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>
> 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
>
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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
> 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/1d5c34d2/attachment-0001.html>
More information about the Pgrouting-users
mailing list