[pgrouting-users] postgis 2.0 and postgresql 9.1
Daniel Kastl
daniel at georepublic.de
Wed Jun 6 12:19:08 PDT 2012
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>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"
>> 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://postgis.refractions.net/pipermail/postgis-users/2012-April/033745.html>
>>> http://www.postgis.org/**download/windows/#postgis-**installers<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/<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<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 <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<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<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<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<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<jfuentes at estudiantes.uci.cu>
>>> <mailto:jfuentes at estudiantes.**uci.cu<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<Pgrouting-users at lists.osgeo.org>
>>> <mailto:Pgrouting-users at lists.**osgeo.org<Pgrouting-users at lists.osgeo.org>
>>> >
>>>
>>> http://lists.osgeo.org/**
>>> mailman/listinfo/pgrouting-**users<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.facebook.com/universidad.uci>
>>> http://www.flickr.com/photos/**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.facebook.com/universidad.uci>
>>> http://www.flickr.com/photos/**universidad_uci<http://www.flickr.com/photos/universidad_uci>
>>> ______________________________**_________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.**org<Pgrouting-users at lists.osgeo.org>
>>> <mailto:Pgrouting-users at lists.**osgeo.org<Pgrouting-users at lists.osgeo.org>
>>> >
>>>
>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-*
>>> *users <http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>
>>>
>>>
>>>
>>> ______________________________**_________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.**org<Pgrouting-users at lists.osgeo.org>
>>> <mailto:Pgrouting-users at lists.**osgeo.org<Pgrouting-users at lists.osgeo.org>
>>> >
>>>
>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**
>>> users <http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>
>>>
>>>
>>> ______________________________**_________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.**org<Pgrouting-users at lists.osgeo.org>
>>> <mailto:Pgrouting-users at lists.**osgeo.org<Pgrouting-users at lists.osgeo.org>
>>> >
>>>
>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**
>>> users <http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>
>>> ______________________________**_________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.**org<Pgrouting-users at lists.osgeo.org>
>>> <mailto:Pgrouting-users at lists.**osgeo.org<Pgrouting-users at lists.osgeo.org>
>>> >
>>>
>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>
>>>
>>> ______________________________**_________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.**org<Pgrouting-users at lists.osgeo.org>
>>> <mailto:Pgrouting-users at lists.**osgeo.org<Pgrouting-users at lists.osgeo.org>
>>> >
>>>
>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>
>>>
>>>
>>> ______________________________**_________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.**org <Pgrouting-users at lists.osgeo.org>
>>> <mailto:Pgrouting-users at lists.**osgeo.org<Pgrouting-users at lists.osgeo.org>
>>> >
>>>
>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>
>>>
>>>
>>>
>>> ______________________________**_________________
>>> Pgrouting-users mailing list
>>> Pgrouting-users at lists.osgeo.**org <Pgrouting-users at lists.osgeo.org> <mailto:
>>> Pgrouting-users at lists.**osgeo.org <Pgrouting-users at lists.osgeo.org>>
>>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>>
>>
>>
>>
>> ______________________________**_________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.**org <Pgrouting-users at lists.osgeo.org>
>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>
>
> ______________________________**_________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.**org <Pgrouting-users at lists.osgeo.org>
> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>
--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120606/7f350f73/attachment-0001.html>
More information about the Pgrouting-users
mailing list