[Tile-serving] [osm2pgsql-dev/osm2pgsql] Support for enums (Issue #2307)

[Paul Norman]

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/2672925505 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250220/1ac79838/attachment.htm>