[postgis-devel] [PostGIS] #373: Documentation syntax error in hard upgrade

[PostGIS]

#373: Documentation syntax error in hard upgrade
---------------------------+------------------------------------------------
 Reporter:  psvensso       |       Owner:  pramsey      
     Type:  defect         |      Status:  new          
 Priority:  medium         |   Milestone:  PostGIS 1.4.1
Component:  postgis        |     Version:  1.4.X        
 Keywords:  documentation  |  
---------------------------+------------------------------------------------
 The instruction in "2.7.2 Hard upgrade" - last sentence on how to empty
 and load updated spatial_ref_sys.sql  gives syntax error (in postgresql
 8.4.x)
 -> You may use truncate to empty the table instead of drop

 When using "drop"
 newdb=# drop spatial_ref_sys;
 ERROR:  syntax error at or near "spatial_ref_sys"
 LINE 1: drop spatial_ref_sys;
              ^

 when using "truncate"
 newdb=# truncate spatial_ref_sys;
 TRUNCATE TABLE

 newdb=# \i /usr/share/contrib/spatial_ref_sys.sql

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