[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