Query truncated in Server Status

Поиск
Список
Период
Сортировка
От Aren Cambre
Тема Query truncated in Server Status
Дата
Msg-id CAA1mBrr_+RqO+tiMz8nRhhtLce2tpg32dKKYw8+XCLiv2Kc=aw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Query truncated in Server Status  (Aren Cambre <aren@arencambre.com>)
Re: Query truncated in Server Status  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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

В списке pgadmin-support по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Dev 1.15 Database Designer
Следующее
От: Aren Cambre
Дата:
Сообщение: Re: Query truncated in Server Status