OK, I have no idea what's going on. I'm using a Mac and successfully installed pgRouting. I used osm2po on some data, which created a sql file. I imported the sql file into a pgRouting database and all is well, except the fact I only took into account routes for cars.
After Carsten helped me with configuring
osm2po.config, I ran osm2po again that ran as expected.
From the terminal, I run the command:
psql -U [username] -d [dbname] -q -f "/Users/John/Desktop/osm2po-4.6.9/wmCar/wmCar/wmCar_2po_4pgr.sql
I was expecting it to be successful like last time, as to my knowledge the conditions are the same. However I get the error:
psql:/Users/John/Desktop/osm2po-4.6.9/wmCar/wmCar_2po_4pgr.sql:101739: ERROR: INSERT has more expressions than target columns LINE 2: ..., -2.0046492, 52.5307149, -2.0026647, 52.5310823, >'010200002...
With pgAdmin I look at the empty table that was created, and compared to the first sql file I imported, the new table was missing a column. That being
geom_way. I find this odd as I haven't changed anything. I threw osm2po folder to the trash, and unzipped a new osm2po folder. To test whether it was going to work, I ran osm2po on the original pbf file with the original
osm2po.config settings and tried to import that into the same pgRouting database. The error appeared again. For some reason, the last column,
geom_way, isn't being added to the table.
Would anyone know why it's started doing this?