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

[mboeringa]

"Identity" is actually a bit different than "serial", in that "serial" defines both a column type and column constraint with a single keyword, while for identity, the column type would be something like "int" or "bigint", and you add the column constraint by adding the ""GENERATED ALWAYS / BY DEFAULT AS IDENTITY" after the specification of the column type.

But if I understand you well, you are saying that if I specify

`column = 'ID', sql_type = 'bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY'`

this would already work in the current implementation?

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