[pgrouting-users] postgis 2.0 and postgresql 9.1
Stephen Woodbridge
woodbri at swoodbridge.com
Wed Jun 6 11:00:18 PDT 2012
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"
> 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>>
>>
>> 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 <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
More information about the Pgrouting-users
mailing list