Every time I started a query the connection with the database is lost. Anyone familiar with this problem?
This problem occurs with various query, for instance:
CREATE TABLE table SELECT a.*, b.column, b.column FROM table_a a JOIN table b ON ST_intersects (a.geom, b.the_geom) WHERE st_IsValid (a.geom);
I just updated from postgis 1.5.3 to 1.5.5 but that doesn't seem to help.
Anyone an idea?
I solved the problem.
There was something wrong with the topology of one of the layers. After editing the query worked without disconnecting.
I find it rather strange that the program and service crashes when the topology is not correct. Can someone shed a light on this issue.