search

GispoCoding / tarmo

Tarmo - Tampere Mobilemap
https://ulkoilutampereenseutu.fi/
MIT License
11 stars 3 forks source link

Move OSM etc. updatable tables to non-sequence primary key #88

Closed Rikuoja closed 2 years ago

Rikuoja commented 2 years ago

OSM table cannot have sequence primary key, as this would result in data duplication, or Integrityerror with the UNIQUE (osm_id, type) constraint.

Generate text primary key "type-osm_id" instead.

Rikuoja commented 2 years ago

Will make a PR soon.

Rikuoja commented 2 years ago

Also tamperewfs_luontorastit seems to need this.