Re: [GENERAL] PostgreSQL service terminated by query

2013-03-26 Thread adrian . kitchingman
query is working without issues. Government men in black will be knocking on your door soon. ;-) Cheers Adrian From: Richard Huxton To: adrian.kitching...@dse.vic.gov.au, Cc: pgsql-general@postgresql.org Date: 26/03/2013 10:32 PM Subject:Re: [GENERAL] PostgreSQL se

Re: [GENERAL] PostgreSQL service terminated by query

2013-03-26 Thread Richard Huxton
On 26/03/13 05:55, adrian.kitching...@dse.vic.gov.au wrote: I'm hoping I can get some info on a query which terminates my PostgreSQL service. The query is a relatively simple PostGIS query: The log text when the service crashes is: 2013-03-26 15:49:55 EST LOG: server process (PID 3536) was

[GENERAL] PostgreSQL service terminated by query

2013-03-25 Thread adrian . kitchingman
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