[pgrouting-users] Error in sampledata_notopo.sql

pgRouting pgrouting-users
1

Dear all,

There is an error in the sampledata_notopo.sql script in the workshop bundle:

psql:/home/user/Desktop/pgrouting-workshop/data/sampledata_notopo.sql:141: ERROR: cannot copy to view “geometry_columns”

I suggest you simply remove lines 139 through 141, they are not needed.

Regards,

Luís

2

On Tue, Apr 9, 2013 at 4:58 PM, Luís de Sousa <luis.a.de.sousa@gmail.com>wrote:

Dear all,

There is an error in the sampledata_notopo.sql script in the workshop
bundle:

psql:/home/user/Desktop/pgrouting-workshop/data/sampledata_notopo.sql:141:
ERROR: cannot copy to view "geometry_columns"

I suggest you simply remove lines 139 through 141, they are not needed.

Hi Luis,

Thanks for reporting. Are you using PostGIS 2.0?
In 1.5 geometry_columns was a table and not a view.
I created a ticket: https://github.com/pgRouting/workshop/issues/16

Daniel

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

3

Hi Daniel, yes I’m using PostGIS 2.0

Regards,

Luís

···

On 9 April 2013 10:30, Daniel Kastl <daniel@georepublic.de> wrote:

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

On Tue, Apr 9, 2013 at 4:58 PM, Luís de Sousa <luis.a.de.sousa@gmail.com> wrote:

Dear all,

There is an error in the sampledata_notopo.sql script in the workshop bundle:

psql:/home/user/Desktop/pgrouting-workshop/data/sampledata_notopo.sql:141: ERROR: cannot copy to view “geometry_columns”

I suggest you simply remove lines 139 through 141, they are not needed.

Hi Luis,

Thanks for reporting. Are you using PostGIS 2.0?
In 1.5 geometry_columns was a table and not a view.
I created a ticket: https://github.com/pgRouting/workshop/issues/16

Daniel

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