[postgis-devel] [PostGIS] #333: VACUUM in spatial_ref_sys.sql throws error

[PostGIS]

#333: VACUUM in spatial_ref_sys.sql throws error
----------------------+-----------------------------------------------------
 Reporter:  kneufeld  |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 1.5.0
Component:  postgis   |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------
 Loading the spatial_ref_sys.sql file manually in PgAdmin III throws the
 error:

 {{{
 ERROR:  VACUUM cannot be executed from a function or multi-command string

 ********** Error **********

 ERROR: VACUUM cannot be executed from a function or multi-command string
 SQL state: 25001
 }}}

 I recommend the two offending lines (1719 and 15142)
 {{{
 VACUUM ANALYZE spatial_ref_sys;
 }}}
 be replaced with
 {{{
 ANALYZE spatial_ref_sys;
 }}}


 VACUUM is not needed anyway since no DELETEs or UPDATEs have taken place,
 only INSERTs - there's no need to reclaim space.

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