From: | Aren Cambre <aren(at)arencambre(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Query truncated in Server Status |
Date: | 2012-02-19 00:54:02 |
Message-ID: | CAA1mBrr_+RqO+tiMz8nRhhtLce2tpg32dKKYw8+XCLiv2Kc=aw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Aren Cambre | 2012-02-19 01:01:08 | Re: Query truncated in Server Status |
Previous Message | Guillaume Lelarge | 2012-02-17 21:33:42 | Re: Dev 1.15 Database Designer |