[postgis-users] Possible Problem with "Hard Upgrade" instructions (UNCLASSIFIED)

[Markus Schaber]

Hello,

strk at refractions.net schrieb:

> > So the fix would be to use:
> > 
> > 	$ psql newdb
> > 	newdb=> truncate spatial_ref_sys;
> > 	TRUNCATE TABLE
> > 	newdb=> \i spatial_ref_sys.sql
> 
> Is 'truncate' available back to PostgreSQL 7.1 ?

Alternatively, "DELETE FROM spatial_ref_sys;" should work (albeit
beeing a bit slower than TRUNCATE).


HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org