Opened 11 years ago
Closed 11 years ago
#2609 closed enhancement (fixed)
topogeo_AddPolygon get rid of DISTINCT
Reported by: | robe | Owned by: | strk |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 2.1.2 |
Component: | topology | Version: | 2.1.x |
Keywords: | Cc: |
Description
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?
Note:
See TracTickets
for help on using tickets.
fixed for 2.1.2 at r12317 and trunk 2.2.0 (at r12316 )