[Tile-serving] [openstreetmap/osm2pgsql] PREPARE SQL statements have inconsistent formatting for spaces (Issue #1693)

[mboeringa]

<!-- Please don't use screenshots. Copy and paste the *text* output here if that's needed for context. -->

## What version of osm2pgsql are you using?

1.6.0 (1.3.0-734-g1f045f9d)

## What operating system and PostgreSQL/PostGIS version are you using?

Ubuntu 20.04.1LTS, PostgreSQL 14.4, PostGIS 3.2


## Tell us something about your system

<!-- How much RAM do you have, how many CPUs, bare metal or cloud setup? -->


## What did you do exactly?

<!-- Please provide the command(s) you used including all options etc. Include
links to input files. -->


## What did you expect to happen?

SQL statements generated by osm2pgsql use proper formatting with no excess spaces between keywords


## What did happen instead?

PREPARE SQL statement have inconsistent number of spaces, where only one space is needed in all of these cases, see output as seen in pgAdmin while import was running:

```
PREPARE get_way(int8) AS  SELECT nodes, tags    FROM "planet_osm_ways" WHERE id = $1;
PREPARE get_way_list(int8[]) AS  SELECT id, nodes, tags    FROM "planet_osm_ways"      WHERE id = ANY($1::int8[]);
```


## What did you do to try analyzing the problem?

<!-- Describe what steps you already did to try analyzing the problem before
reporting. -->



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

Message ID: <openstreetmap/osm2pgsql/issues/1693 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220716/4c41aaad/attachment.htm>