[postgis-devel] [PostGIS] #1802: Ensure interruptability of long-running calls

[PostGIS]

#1802: Ensure interruptability of long-running calls
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  strk         
     Type:  task     |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.1
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 Mark: maybe you don't feel the problem as you never had it.
 Try running this query:

 {{{
 set statement_timeout to 1000;
 select st_buffer(st_collect(geom), 1e5) from ( select
 (st_dumppoints(st_buffer(st_point(0,0), 1e4, 150))).geom ) as foo;
 }}}

 And see if it stops, as requested, after one second.
 Oh, you might need to hard-kill the backend to take back control of your
 machine, so be prepared...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1802#comment:16>
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.