Hmm, the magical number is not 250 characters. This query got truncated at character 374:
8640Quantum GISdepostgres::1:602812012-02-18 18:56:15.869-062012-02-18 18:56:15.893-062012-02-18 18:56:15.893-06select distinct case when upper(geometrytype("the_geom")) IN ('POINT','MULTIPOINT') THEN 'POINT' when upper(geometrytype("the_geom")) IN ('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when upper(geometrytype("the_geom")) IN ('POLYGON','MULTIPOLYGON') THEN 'POLYGON' end from (select "the_geom" from "raw"."dallas_rlc_summary" where "the_geom" is not null limit 100) as t
In the Server Status program, long queries get truncated.
Pressing Ctrl-C or the Copy button on a recent query put this in the clipboard:
9368de34132postgres6/528AccessShareLockYes2012-02-18 18:46:14.759-06select distinct case when upper(geometrytype("the_geom")) IN ('POINT','MULTIPOINT') THEN 'POINT' when upper(geometrytype("the_geom")) IN ('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when upper(geometrytype("the_geom")) IN ('POLYGON','MULTIPOLYG
Looks like the query got truncated at the 250th character. I've reproduced on other queries.
I'm OK if the query needs to be truncated to fit in the UI, but the whole query ought to be copied to the clipboard. This is making it challenging for me to analyze a problematic Quantum GIS query.