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

[mboeringa]

PostgreSQL 10 introduced the "Identity" column constraint for unique ID columns with SQL standard definition ("GENERATED ALWAYS / BY DEFAULT AS IDENTITY"), which has several advantages over the "serial" type. Maybe it would be an idea to at least allow specifying this sql_type instead of serial, or default to it for PostgreSQL 10+:

https://www.depesz.com/2017/04/10/waiting-for-postgresql-10-identity-columns/

https://www.postgresql.org/docs/current/sql-createtable.html

-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210710/46d07aee/attachment.htm>