hi list,
i have a problem with running these querys:
SELECT
AddGeometryColumn('public','_g2994','the_geom_1','4326','MULTIPOLYGON',2);
ALTER TABLE _g2994 DROP CONSTRAINT enforce_geotype_the_geom_1;
ALTER TABLE _g2994 ADD CONSTRAINT enforce_geotype_the_geom_1 CHECK
(geometrytype(the_geom_1) = 'MULTIPOLYGON'::text OR geometrytype(the_geom_1) =
'POLYGON'::text OR the_geom_1 IS NULL);
everthing is alright up to here...
then i run
UPDATE _g2994 SET the_geom_1 = buffer(simplify(the_geom,0.0063775005),0) WHERE
true
and nothing happens except that i get a message ': ' back from pgAdmin
if i try to run any query after that strange phenomenom i get a message, that
there is not connection to the server and i have to refresh the connection to
the server before i can run any other query again.
if i try the
UPDATE _g2994 SET the_geom_1 = buffer(simplify(the_geom,0.0063775005),0) WHERE
true with JDBC i get the following exception
org.postgresql.util.PSQLException: An I/O error occured while sending to the
backend
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:286)
does anybody know, what is wrong?
_______________________________________________________________________
Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate
kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
