Re: [GENERAL] PostgreSQL service terminated by query

Thanks for the suggestion Richard. I dumped the two tables in question and restored them which got the query working for a while until it eventually crashed the service again at another gid. I'll do a RAM check tonight. I transferred the whole database to another computer and so far the query i

[GENERAL] PostgreSQL service terminated by query

I'm hoping I can get some info on a query which terminates my PostgreSQL service. The query is a relatively simple PostGIS query: SELECT en.gid, ST_LENGTH(en.geom) total_length, (ST_DUMP(ST_INTERSECTION(en.geom, evc.geom))).geom::geometry(Linestring, 3111) geom FROM en, evc