Table "ways" has "gid" as id

[Doev]

The table "ways" has "gid" as id, but pgrouting set a default to "id". It is not really a problem, but as a beginner you have to find out first.

For example:

select pgr_analyzegraph('ways', 0.000001); -> Fail
select pgr_analyzegraph('ways', 0.000001, 'the_geom', 'gid', 'source', 'target', 'true'); -> OK

[dkastl]

gid is frequently used with spatial data in PostgreSQL/PostGIS and so it has been for long time used as default in pgRouting functions and documentation. It's similar to name the geometry colum the_geom and not geom.

id isn't a default term either. Some may name it uid, rid or vid. If you are not happy with the extra function parameters, you can easily create a VIEW of your table to match with the defaults.

Because changing something like this would be confusing for many, probably will break backwards compatibility and just causes extra work with (in my opinion) no real benefit, pgRouting is not planning to change the status quo.

[Doev]

I agree, but the table "ways_vertices_pgr" is using "id" and not "gid" as primary key.