Double quote PostgreSQL table names in the backend about incubator-baremaps HOT 2 CLOSED

Would it be possible to quote (/check for) double quote around the PostgreSQL table names in the backend?

I think so, could you provide me with a greater excerpt of the config in order to reproduce the error?

from incubator-baremaps.

I suspect the PostgreSQL layer name MUST be escaped in the SQL query defined in the ./config/layer.yaml file, especially when they contain non standard SQL characters such as capital letters or digits, because when I escape the layer name using double quotes, it doesn't print this error at startup.

Yes, it has to be escaped. Also, notice that the zoom level is supposed to be part of the table name. I tried to reproduce your case and I think it is working. Assuming that a table named 1_differential_rabbiHousing_z14 exists in the database, baremaps will be able to create tiles (at zoom level 14) that include the following layer:

id: mylayer
type: linestring
queries:
  - minZoom: 14
    maxZoom: 14
    sql: |
      SELECT id, tags, geom
      FROM "1_differential_rabbiHousing_z${zoom}"

The following exerpt (quoted from your comment) is supposed to fail:

FROM "1_differential_rabbiHousing"${zoom}

I'm not sure whereas the layer and id in the stylesheet has to represent the same object and what they do refer to?

Not necessarily, but naming things is hard... ;)

from incubator-baremaps.