[Tile-serving] [openstreetmap/osm2pgsql] Switch to "Identity" columns instead of "Serial" for PostgreSQL 10+ (#1538)

[Ryan Lambert]

> I did realize there is another reason good reason to switch to 'identity' though: I noticed in DBeaver it appears the 'serial' column type is created as 'int4' by default by PostgreSQL. While not an immediate concern, it is clear though that eventually one may run out of values with 'int4' and the ever growing OpenStreetMap database... It is not without reason osm_id has been 'int8' for quite some time.

@mboeringa Using `bigserial` instead of `serial` will create `int8`. `IDENTITY` is still the preferred method though, it conforms to the SQL standard and makes permissions easier to manage.

-- 
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/discussions/1538#discussioncomment-989287
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210710/d745870f/attachment.htm>