[postgis-devel] [PostGIS] #1522: [RASTER] ST_MapAlgebraExpr : use prepared queries

PostGIS trac at osgeo.org
Mon Feb 6 10:33:07 PST 2012


#1522: [RASTER] ST_MapAlgebraExpr : use prepared queries
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  dzwarg       
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.0.0
Component:  raster       |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by dzwarg):

 The Postgresql docs state that SPI_Execute will: "Parse, plan, and execute
 a query string".

 Looking at the internals, it seems like SPI_execute creates a plan and
 executes it the same way that I would go about preparing the plan in order
 to make this change. Is there something that I'm missing about how
 prepared statements work that would make explicit plan preparation
 necessary?

 See
 http://doxygen.postgresql.org/spi_8c.html#af7dc8e377b122d8c8758426f14d38889
 for sourcecode docs for postgresql.

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