G'day all,
having just (I think) upgraded PostGIS from 1.3.6 to 1.4.0 (still in
PostgreSQL 8.3.7) I moved on in the documentation to :
spatial_ref_sys table is restore from the dump, to ensure your custom
additions are kept, but the distributed one might contain modification
so you should backup your entries, drop the table and source the new
one. If you did make additions we assume you know how to backup them
before upgrading the table. Replace of it with the new one is done
like this:
$ psql newdb
newdb=> drop spatial_ref_sys;
DROP
newdb=> \i spatial_ref_sys.sql
but got the following message :
australia=# \i /usr/local/pgsql/share/contrib/spatial_ref_sys.sql
BEGIN
psql:/usr/local/pgsql/share/contrib/spatial_ref_sys.sql:5: ERROR:
relation "spatial_ref_sys" does not exist
Lines 1 to 5 of spatial_ref_sys.sql are :
BEGIN;
---
--- EPSG 3819 : HD1909
---
INSERT INTO
"spatial_ref_sys
" ("srid","auth_name","auth_srid","srtext","proj4text") VALUES
(3819,'EPSG',3819,'GEOGCS["HD1909",DATUM
["Hungarian_Datum_1909",SPHEROID["Bessel 1841",
6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84
[595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408],AUTHORITY
["EPSG","1024"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT
["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY
["EPSG","3819"]]','+proj=longlat +ellps=bessel
+towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs ');
so there is no table definition in the spatial_ref_sys.sql file.
I would wonder if maybe truncate spatial_ref_sys; might be a better
option...
In the meantime, does anyone have the table definition for
spatial_ref_sys.sql...?
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
[email protected]
Out here, it pays to
know...
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
