Re: Query truncated in Server Status

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 <aren(at)arencambre(dot)com> 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
>