Postgres Pro
Downloads
Home   >   mailing lists

Re: Query truncated in Server Status - Mailing list pgadmin-support

From Aren Cambre
Subject Re: Query truncated in Server Status
Date
Msg-id CAA1mBro_sGCzf-0JN9FU4cmwEBkWWSjuFC1e5YZPDcJD1TvOCQ@mail.gmail.com
Whole thread Raw
In response to Query truncated in Server Status  (Aren Cambre <aren@arencambre.com>)
List pgadmin-support
Tree view
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@arencambre.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

pgadmin-support by date:

Previous
From: Aren Cambre
Date:
Subject: Query truncated in Server Status
Next
From: Guillaume Lelarge
Date:
Subject: Re: Query truncated in Server Status