pnorman left a comment (osm2pgsql-dev/osm2pgsql#2307)
In practice, you can either have a sortable ordering, or you can alter types.
When you use ALTER TYPE you can't pick where in the ordering it goes. You end
up having to reimport or update all rows if you want to insert in the middle of
your enum.
I wrote a bunch of stuff with ClearTables that made use of ENUMs, but threw it
away. The main use I find for ENUMs now is for values which might be something
like -1/0/1 such as tunnel/bridge.
--
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/issues/2307#issuecomment-2672925505
You are receiving this because you are subscribed to this thread.
Message ID: <osm2pgsql-dev/osm2pgsql/issues/2307/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving
