[postgis-devel] [PostGIS] #918: two bugs in Populate_Geometry_Columns(oid)

PostGIS trac at osgeo.org
Wed Apr 20 02:21:50 PDT 2011

#918: two bugs in Populate_Geometry_Columns(oid)
 Reporter:  nicklas  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
 From report by Anders Söderman that Populate_Geomtry_columns gives primary
 key violation in geometry_columns table

 Populate_geoemtry_columns(oid) does not delete old entries in
 geometry_columns if the tabel or schema name includes characters that
 makes need of double quoting.

 It is working when there is no need for double quoting because quote_ident
 don't quote when not needed.

 Second bug is that that entries for views is not deleted at all before the
 function tries to add a new one which also causes a primary key violation

Ticket URL: <http://trac.osgeo.org/postgis/ticket/918>
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-devel mailing list