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

[Markus Schaber]

Hi, Gino,

Markus Schaber schrieb:

> 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.

The SQL command to enable deferred constraints checking is "SET
CONSTRAINTS DEFERRED", as documented under
http://www.postgresql.org/docs/7.4/interactive/sql-set-constraints.html

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: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050126/24f2b9c2/attachment.pgp>