[postgis-tickets] [PostGIS] #2609: topogeo_AddPolygon get rid of DISTINCT

[PostGIS]

#2609: topogeo_AddPolygon get rid of DISTINCT
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  strk         
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.2
Component:  topology     |     Version:  2.1.x        
 Keywords:               |  
-------------------------+--------------------------------------------------
 I noticed that topogeo_AddPolygon has a DISTINCT


 {{{
 'SELECT DISTINCT f.face_id FROM ' || quote_ident(atopology)
     || '.face f WHERE f.mbr && '
     || quote_literal(apoly::text)
     || '::geometry';
 }}}

 Which seems totally pointless given that face_id is the primary key of
 face.  I'm sure PostgreSQL is probably smart enough to figure it doesn't
 need to but it shouldn't be bothered.

 Am I missing something?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2609>
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.