[pgrouting-users] postgis 2.0 and postgresql 9.1

Pedro_Costa · May 22, 2012, 11:05am

Hi,

Does anyone know anything about postgresql 9.1 and postgis 2 withpgrouting?
There will be some sort of compatibility?

Thanks

Pedro

Jorge_Fuentes · May 22, 2012, 3:48pm

Yes I had them install and running PosgreSQL 9.1.3, postGIS 2.0 and pgrouting on win 7-32bits

El 22/05/2012 7:05 am, Pedro Costa escribió:

Hi,

Does anyone know anything about postgresql 9.1 and postgis 2 withpgrouting?
There will be some sort of compatibility?

Thanks

Pedro
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@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

Pedro_Costa · May 22, 2012, 4:35pm

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

Jorge_Fuentes · May 22, 2012, 6:11pm

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@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

sanak · May 22, 2012, 10:42pm

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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pedro_Costa · May 23, 2012, 10:13am

Perfect…works…

Thanks

James_David_Smith · May 23, 2012, 10:18am

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@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pedro_Costa · May 23, 2012, 10:30am

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@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Ricardo_Bayley · June 4, 2012, 2:02pm

Is there a build for postgis under windows in a 64bit enviroment ?

thanks

2012/5/23 Pedro Costa <pedrocostaarma@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@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

sanak · June 5, 2012, 2:40am

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@gmail.com>

Is there a build for postgis under windows in a 64bit enviroment ?

thanks

2012/5/23 Pedro Costa <pedrocostaarma@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@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@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@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pedro_Costa · June 6, 2012, 4:53pm

I’m trying now with postgis 2.0 and successfully create the template for 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

Stephen_Woodbridge1 · June 6, 2012, 6:00pm

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@gmail.com
<mailto:ricardo.bayley@gmail.com>>

    Is there a build for postgis under windows in a 64bit enviroment ?

    thanks

    2012/5/23 Pedro Costa <pedrocostaarma@sapo.pt
    <mailto:pedrocostaarma@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@sapo.pt
            <mailto:pedrocostaarma@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@estudiantes.uci.cu
                <mailto:jfuentes@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@lists.osgeo.org
                        <mailto:Pgrouting-users@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@lists.osgeo.org
                    <mailto:Pgrouting-users@lists.osgeo.org>
                    http://lists.osgeo.org/mailman/listinfo/pgrouting-users

                _______________________________________________
                Pgrouting-users mailing list
                Pgrouting-users@lists.osgeo.org
                <mailto:Pgrouting-users@lists.osgeo.org>
                http://lists.osgeo.org/mailman/listinfo/pgrouting-users

                _______________________________________________
                Pgrouting-users mailing list
                Pgrouting-users@lists.osgeo.org
                <mailto:Pgrouting-users@lists.osgeo.org>
                http://lists.osgeo.org/mailman/listinfo/pgrouting-users

            _______________________________________________
            Pgrouting-users mailing list
            Pgrouting-users@lists.osgeo.org
            <mailto:Pgrouting-users@lists.osgeo.org>
            http://lists.osgeo.org/mailman/listinfo/pgrouting-users

        _______________________________________________
        Pgrouting-users mailing list
        Pgrouting-users@lists.osgeo.org
        <mailto:Pgrouting-users@lists.osgeo.org>
        http://lists.osgeo.org/mailman/listinfo/pgrouting-users

    _______________________________________________
    Pgrouting-users mailing list
    Pgrouting-users@lists.osgeo.org
    <mailto:Pgrouting-users@lists.osgeo.org>
    http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org <mailto:Pgrouting-users@lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

dkastl · June 6, 2012, 7:19pm

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@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://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@gmail.com

mailto:[ricardo.bayley@gmail.com](mailto:ricardo.bayley@gmail.com)>

Is there a build for postgis under windows in a 64bit enviroment ?

thanks

2012/5/23 Pedro Costa <pedrocostaarma@sapo.pt

mailto:[pedrocostaarma@sapo.pt](mailto:pedrocostaarma@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@sapo.pt

mailto:[pedrocostaarma@sapo.pt](mailto:pedrocostaarma@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@estudiantes.uci.cu

mailto:[jfuentes@estudiantes.uci.cu](mailto:jfuentes@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@lists.osgeo.org

mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@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@lists.osgeo.org

mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)

http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org

mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)

http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org

mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)

http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org

mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)

http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org

mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)

http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org

mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)

http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list

Pgrouting-users@lists.osgeo.org mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Pedro_Costa · June 6, 2012, 8:37pm

Em 06-06-2012 19:00, Stephen Woodbridge escreveu:

select Populate_Geometry_Columns();

should fix this.

-Steve

Hi Steve,

I did it but the error continues.

The result of select populate_geometry_columns was that:

"probed:1 inserted:0"

Pedro_Costa · June 6, 2012, 8:41pm

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