Applying srid.sql still does not work
4 views
Skip to first unread message
Arto Vuorela
Oct 25, 2010, 4:53:12 AM10/25/10
to zig...@googlegroups.com
Referring to http://groups.google.com/group/ziggis/browse_thread/thread/1125012bc61d4a46/e5ccde28a24f188a,
the zigGIS 2.0.5 srid.sql was not appending its coordinate system definitions in the table created with pgAdmin III 1.10.3 from PostgreSQL 8.4.4-1 and PostGIS 1.5.1-1. I think the reason at least in the last trials was that the key attribute would not be unique because the first key value 4023 already exists in the table (the second one not). I've understood that even with one error, a rollback happens.
Arto
the zigGIS 2.0.5 srid.sql was not appending its coordinate system definitions in the table created with pgAdmin III 1.10.3 from PostgreSQL 8.4.4-1 and PostGIS 1.5.1-1. I think the reason at least in the last trials was that the key attribute would not be unique because the first key value 4023 already exists in the table (the second one not). I've understood that even with one error, a rollback happens.
Arto
Abe Gillespie
Oct 25, 2010, 8:46:29 AM10/25/10
to zig...@googlegroups.com
Arto,
I've already responded. But I can give you additional information.
If, in fact, it's 4023 that's causing the problem then all you need to
do is remove the INSERT statement with 4023 and it will succeed.
-Abe
> --
> You received this message because you are subscribed to the Google Groups
> "zigGIS" group.
> To post to this group, send email to zig...@googlegroups.com.
> To unsubscribe from this group, send email to
> ziggis+un...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/ziggis?hl=en.
>
Reply all
Reply to author
Forward
0 new messages