[Tile-serving] [openstreetmap/osm2pgsql] Set default schema to 'public' and use qualified names everywhere (PR #2027)

[mboeringa]

The problem is that while I can set 'schema=X' in a flex style file to determine the schema to store all output tables, I cannot set the schema for where to store 'osm2pgsql_properties' table on the command line (or in the style file).

If you do not want to use `search_path`, as discussed in https://github.com/openstreetmap/osm2pgsql/issues/2011, then maybe use the user name as specified with the **-U** osm2pgsql command line option, assuming as you wrote there, that best practice is to use the user name also as the schema name. Then simply error out if this fails and you cannot write there?

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

Message ID: <openstreetmap/osm2pgsql/pull/2027/c1674405326 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230811/bc93d8aa/attachment.htm>