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

[Rob Tester]

First the ":" and your jdbc error means the postgres service has had to
restart. The connection was terminated due to an error.

The questions that come to mind are the following:

What is the_geom? I see the_geom_1 but not the_geom.

Why are you buffering with a value of 0?

Why have a where clause at all for what you are doing? If you wanted to set
all of the_geom_1 values just leave off the where clause.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stefan
Zweig
Sent: Monday, August 13, 2007 8:46 AM
To: PostGIS Users Discussion
Subject: [postgis-users] An I/O error occured while sending to the backend

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.j
ava:452)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:340)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2State
ment.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
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users