[postgis-devel] [PostGIS] #1797: validatetopology error when asking for column names

[PostGIS]

#1797: validatetopology error when asking for column names
----------------------+-----------------------------------------------------
 Reporter:  jomarlla  |       Owner:  strk         
     Type:  defect    |      Status:  new          
 Priority:  low       |   Milestone:  PostGIS 2.0.1
Component:  topology  |     Version:  2.0.x        
 Keywords:            |  
----------------------+-----------------------------------------------------
 Something is going wrong with the create temp table when one try to use
 select (validatetopology ('t1')).*;


 This is ok.

 {{{
 s9=# select validatetopology ('t1');
  validatetopology
 ------------------
 (0 rows)
 }}}


 now the error:

 {{{
 s9=# select (validatetopology ('t1')).*;
 ERROR:  relation "face_check" already exists
 CONTEXT:  SQL statement "CREATE TEMP TABLE face_check ON COMMIT DROP AS
 SELECT face_id, topology.ST_GetFaceGeometry('t1', face_id) as geom, mbr
 FROM t1.face WHERE face_id > 0"
 PL/pgSQL function "validatetopology" line 204 at EXECUTE statement
 }}}

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