[Tile-serving] [osm2pgsql-dev/osm2pgsql] Proposal for new data types (Issue #2274)

[Jochen Topf]

joto left a comment (osm2pgsql-dev/osm2pgsql#2274)

@EssBee59 Please do not reuse an existing issue for something unrelated, open a [new discussion](https://github.com/osm2pgsql-dev/osm2pgsql/discussions/new/choose) instead.

For your problem: You can not run SQL queries on import, that's not possible with osm2pgsql and most likely will never be, because we are using the COPY command. Have a look at the [chapter on geometry objects in the manual](https://osm2pgsql.org/doc/manual.html#geometry-objects-in-lua). Maybe you can use the `length` and `transform` functions to do what you need. If not, create a `real` column in your table and use the `create_only` setting. Then after running osm2pgsql use an SQL `UPDATE merca_coef = ... WHERE merca_coef IS NULL` to fill in that column.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/issues/2274#issuecomment-2729461683
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/issues/2274/2729461683 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250317/a1eadd21/attachment.htm>