[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:            |  
----------------------+-----------------------------------------------------

Comment(by strk):

 Ouch. I think this is due to what could be considered like a bug (IMHO) of
 PostgreSQL, that is the fact that a set-returning function called with the
 syntax: (srf()).* gets expanded as multiple calls to the function (one per
 returning column) and results in actual calls rather than reusing the
 result from the function (I think the function is STABLE).

 So, since the function creates a temporary table, with transaction
 lifetime, the second call finds the table already existing and bails out.

 Not sure how could this be fixed, except maybe by avoiding the creation of
 the temporary table (which would slow things down considerably).

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