Opened 9 years ago

Closed 9 years ago

#373 closed defect (fixed)

Documentation syntax error in hard upgrade

Reported by: psvensso Owned by: pramsey
Priority: medium Milestone: PostGIS 1.4.2
Component: postgis Version: 1.4.X
Keywords: documentation Cc:


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

Change History (2)

comment:1 Changed 9 years ago by pramsey

Milestone: PostGIS 1.4.1PostGIS 1.4.2

comment:2 Changed 9 years ago by pramsey

Resolution: fixed
Status: newclosed

Thanks! Fixed in 1.4, 1.5, and trunk as of r5391.

Note: See TracTickets for help on using tickets.