[postgis-users] Small oversights in PostGIS 1.0 RC1 and migration help

[Markus Schaber]

Hi, Gino,

Gino Lucrezi schrieb:

> Obviously, in an existing DB, I can't just drop the table and recreate it according to the newest spatial_ref_sys.sql file, because there are constraints forbidding it; is there any simple way to do it?

Play the data into a temporary new table, and then do a "BEGIN; delete
from spatial_ref_sys; insert into spatial_ref_sys select * from
temp_table; commit" with delayed constraints checking.

Maybe you can also make use of the dump_split script I posted to psql
mailing list some days ago, I also attached it to this message. It
separates schema and tables into different files, so you can still edit
the schema by hand even on large volume databases and restore single tables.

HTH,
Markus


--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios at logi-track.com | www.logi-track.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dump_split.sh
Type: application/x-shellscript
Size: 1274 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050126/717c5a2c/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050126/717c5a2c/attachment.pgp>