[Tile-serving] [openstreetmap/osm2pgsql] Duplicated serial values when appending data to flex backend (#1522)

[Nikolai Lebedev]

Constraint is used just to demonstrate an issue.
[Manual](https://osm2pgsql.org/doc/manual.html#using-an-additional-id-column) does allow to use `serial` type.
You can add a constraint after initial import as manual suggests.

The problem rises when you run `append` to this data. Sequence does not continue to increment for newly added rows, but instead runs from start. This leads to duplicating values for this serial column.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1522#issuecomment-856797103
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210608/2fff3253/attachment-0001.htm>