[PostGIS] #5697: fix or document id escaping for ST_EstimatedExtent params
PostGIS
trac at osgeo.org
Sat Mar 16 02:12:36 PDT 2024
#5697: fix or document id escaping for ST_EstimatedExtent params
----------------------+---------------------------
Reporter: Yuri | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.4.3
Component: postgis | Version: 3.4.x
Resolution: | Keywords:
----------------------+---------------------------
Comment (by Yuri):
After lots of back and forth, it seems this **may** work:
* for schema, use identifier escaping rules to produce a double-quoted
string, and afterwards remove the first and last double-quote character.
* do the same for the table
* pass geometry column as is
Which means that when calling, schema and table name have to first be
encoded as identifiers, remove first/last `"`, and then encode using
literal string encoding. The geometry must only be literally encoded...
Uncertain of this, but seems to work in some testing...
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5697#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list