[Tile-serving] [osm2pgsql-dev/osm2pgsql] Refuse to import data when there is an osm2pgsql_properties table (PR #2085)

[Jochen Topf]

@rustprooflabs If this PR would be merged, you can still import into as many schemas as you like, but you have to do this in one go. So you have to have one configuration. Having two completely separate configurations in the same database isn't possible, you have to use separate databases for that. That all follows from the properties table always being in the same place. And that is important so it can do its job as the "root" of everything. If it would be possible to have the properties table in separate schemas, osm2pgsql could not autoconfigure from that, because osm2pgsql would not know how to look for that table. So it is on purpose that there is no way to say in which schema the properties table is.

All of that is only really so for the case where you want to update the database, because that is the reason after all why we want that properties table, so updates are simpler. If you want to do several imports that don't need updates, you can always just delete the properties table after the import and before the next one. (Or at the moment, before this PR or something like it is merged, just do it and osm2pgsql will overwrite the table.) This is no different than before with the tables created by the osm2pgsql-replication script.

And even if you want to do updates you can remove that properties table and do the updates manually, for backwards compatibility osm2pgsql can still run in append mode without the properties table.

So you can still do all the things you could do before. But the most common case is simpler with the properties table, and with this PR slightly safer.

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

Message ID: <osm2pgsql-dev/osm2pgsql/pull/2085/c1846766796 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20231208/ad26cae1/attachment.htm>