[Tile-serving] [openstreetmap/osm2pgsql] Executing custom SQL after Lua insert (Discussion #1768)

[Fabian Freund]

I want to post process an added row by using a custom query, right after the insert. At this stage I need PostGIS to process the geometries, which is not possible with the limited features in osm2pgsql.

I could just use the osmid to update the table right after the insert by using e.g. a lua postgres client inside the script, but the problem here will be that no index is created yet. Doing a full table scan after each insert will take a long time for my number of rows. Since osm2pgsql is not having start/finish callbacks I also cannot create them myself at an earlier stage (when this is possible, triggers would be much better).

How I can handle this?



-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/discussions/1768
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/repo-discussions/1768 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220919/7d3b3872/attachment.htm>