[postgis-devel] [PostGIS] #301: [raster] Add uninstall_rtpostgis.sql machinery

[PostGIS]

#301: [raster] Add uninstall_rtpostgis.sql machinery
-----------------------------------+----------------------------------------
 Reporter:  mloskot                |       Owner:  strk         
     Type:  enhancement            |      Status:  assigned     
 Priority:  medium                 |   Milestone:  PostGIS 2.0.0
Component:  build/upgrade/install  |     Version:  trunk        
 Keywords:                         |  
-----------------------------------+----------------------------------------
Changes (by strk):

  * owner:  robe => strk
  * status:  new => assigned


Comment:

 No problem, the create_undef.pl way is still going good (overnight :)

 I've improved the stripper for DEFAULT spec and changed the default to 0,
 matching what postgis.sql does. Now the uninstall_rtpostgis.sql comes out
 well-formed and I think it works cleaning everything out.

 Next problem _enabling_ automated testing for it is that the regression
 test of raster is creating a data table for use by tests and never
 dropping it. It is advisable that every test needing that table includes
 (\i) the creator as first thing and includes a "dropper" as last thing.

 Will take more time but would allow you to run each test in isolation,
 which is important while debugging specific bugs.

 For the time being I'm adding to the hack by listing a drop_xxy testcase
 the same way as it is done with create_xxxy testcase (fakes).

 Also, I'm cleaning up tests that create objects internally to drop them as
 last step.
 Plain raster uninstall seems to work very well.

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