Hmm, the magical number is not 250 characters. This query got truncated at
character 374:
*8640 Quantum GIS de postgres ::1:60281 2012-02-18 18:56:15.869-06 2012-02-18
18:56:15.893-06 2012-02-18 18:56:15.893-06 select 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*On Sat, Feb 18, 2012 at 6:54 PM, Aren Cambre <[email protected]> wrote: > 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: > *9368 de 34132 postgres 6/528 AccessShareLock Yes 2012-02-18 > 18:46:14.759-06 select 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. > > Aren Cambre >
