[postgis-users] An I/O error occured while sending to the backend

[Stefan Zweig]

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