[postgis-tickets] [PostGIS] #3093: st_estimatedextent error with mixed case table names
PostGIS
trac at osgeo.org
Tue Mar 31 09:30:37 PDT 2015
#3093: st_estimatedextent error with mixed case table names
-----------------------+----------------------------------------------------
Reporter: lpercich | Owner: pramsey
Type: defect | Status: closed
Priority: low | Milestone: PostGIS 2.1.7
Component: postgis | Version: 2.1.x
Resolution: wontfix | Keywords:
-----------------------+----------------------------------------------------
Comment(by lpercich):
I submitted this to the QGIS tracker, because I spotted the problem in
QGIS:
http://hub.qgis.org/issues/12478
Probably they'll hardcode the double quotes in the function call, unless
you are going to change the function behaviour.
I agree with letting things the way they are, even if it is inconsistent
with other PG function expecting table names and schemas as parameters.
The plus of course would be having the function accept both quoted and
unquoted string arguments. There's non reason why I should call
st_estimetedextent('PUBlic', 'MyTable') when looking for public.mytable:
so why don't we make the function work with both '"MyTable"' and 'MyTable'
or, for the lowercase name, 'mytable'?
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3093#comment:4>
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