[postgis-users] ST_EstimatedExtent and identifier case sensitivity rules
Mateusz Loskot
mateusz at loskot.net
Fri Aug 9 09:36:30 PDT 2019
Hi,
I create a table using:
CREATE TABLE "AbCdEfG" (...)
I run:
SELECT ST_EstimatedExtent('public', 'AbCdEfG', 'g')
Using PostGIS 2.1.3, this fails with "public.abcdefg relation does not exist"
Using PostGIS 2.5.2, it succeeds.
Using 2.1.3, am I just lucky to hit this regression fixed in 2.1.4?
https://trac.osgeo.org/postgis/ticket/2834
Generally, assuming no regressions occur, is this correct to
assume functions taking identifiers as literals like
ST_EstimatedExtent, AddGeometryColumn
are case-insensitive, even if tables and columns were created
as case-sensitive (double-quoted)?
Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
More information about the postgis-users
mailing list