[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