[Mapserver-users] How to delete a GIST Index in gc_ok

[christian.schuster at rsag.ch]

This is a multipart message in MIME format.
--=_alternative 004C9157C1256CBE_=
Content-Type: text/plain; charset="US-ASCII"

Hi list,

I had a table 'geo' with a geometry column of type point and also a GIST 
index. Then I deleted this table as well as the index belonging to it and 
create it again. So far okay. But as I wanted to add the geometry column I 
received the following error message. To work around this problem I 
renamed the table in to geo2 and then I could add the geometry column.

I am working on Win2000 with Cygwin, PostgreSQL-7.3.1-1 and PostGIS-0.7.3

Does anyone know how to delete the key in index gc_ok?

Thanks for your help.


myGISdb=# create table geo (ID int4, NAME varchar(20));
CREATE TABLE
myGISdb=# select addgeometrycolumn('myGISdb', 'geo', 'geom', -1, 'POINT', 
2);
ERROR:  Cannot insert a duplicate key into unique index gc_ok
WARNING:  Error occurred while executing PL/pgSQL function 
addgeometrycolumn
WARNING:  Error occurred while executing PL/pgSQL function 
addgeometrycolumn
WARNING:  line 39 at execute statement
WARNING:  line 39 at execute statement
ERROR:  Cannot insert a duplicate key into unique index gc_ok

Christian Schuster

Rudolf Schuster AG
Postfach 277
CH - 3000 Bern 11

http://www.rsag.ch
++41 31 348 05 30
--=_alternative 004C9157C1256CBE_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=2 face="sans-serif">Hi list,</font>
<br>
<br><font size=2 face="sans-serif">I had a table <b>'geo'</b> with a geometry
column of type <b>point</b> and also a GIST index. Then I deleted this
table as well as the index belonging to it and create it again. So far
okay. But as I wanted to add the geometry column I received the following
error message. To work around this problem I renamed the table in to geo2
and then I could add the geometry column.</font>
<br>
<br><font size=2 face="sans-serif">I am working on Win2000 with Cygwin,
PostgreSQL-7.3.1-1 and PostGIS-0.7.3</font>
<br>
<br><font size=2 face="sans-serif">Does anyone know how to delete the key
in index gc_ok?</font>
<br>
<br><font size=2 face="sans-serif">Thanks for your help.</font>
<br>
<br>
<br><font size=2 face="sans-serif"><b>myGISdb=# create table geo (ID int4,
NAME varchar(20));</b></font>
<br><font size=2 face="sans-serif"><b>CREATE TABLE</b></font>
<br><font size=2 face="sans-serif"><b>myGISdb=# select addgeometrycolumn('myGISdb',
'geo', 'geom', -1, 'POINT', 2);</b></font>
<br><font size=2 face="sans-serif"><b>ERROR:  Cannot insert a duplicate
key into unique index gc_ok</b></font>
<br><font size=2 face="sans-serif"><b>WARNING:  Error occurred while
executing PL/pgSQL function addgeometrycolumn</b></font>
<br><font size=2 face="sans-serif"><b>WARNING:  Error occurred while
executing PL/pgSQL function addgeometrycolumn</b></font>
<br><font size=2 face="sans-serif"><b>WARNING:  line 39 at execute
statement</b></font>
<br><font size=2 face="sans-serif"><b>WARNING:  line 39 at execute
statement</b></font>
<br><font size=2 face="sans-serif"><b>ERROR:  Cannot insert a duplicate
key into unique index gc_ok</b></font>
<br><font size=2 face="sans-serif"><br>
Christian Schuster<br>
<br>
Rudolf Schuster AG<br>
Postfach 277<br>
CH - 3000 Bern 11<br>
<br>
http://www.rsag.ch<br>
++41 31 348 05 30</font>
--=_alternative 004C9157C1256CBE_=--