Re: [pgadmin-support] Query truncated in Server Status

2012-02-19 Thread Aren Cambre
Thanks! Yes, I am using Windows. Aren On Sun, Feb 19, 2012 at 5:12 AM, Guillaume Lelarge wrote: > On Sun, 2012-02-19 at 10:23 +0100, Guillaume Lelarge wrote: > > On Sat, 2012-02-18 at 18:54 -0600, Aren Cambre wrote: > > > In the Server Status program, long queries get truncated. > > > > > > Pres

Re: [pgadmin-support] Query truncated in Server Status

2012-02-19 Thread Guillaume Lelarge
On Sun, 2012-02-19 at 10:23 +0100, Guillaume Lelarge wrote: > On Sat, 2012-02-18 at 18:54 -0600, Aren Cambre 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 postgre

Re: [pgadmin-support] Query truncated in Server Status

2012-02-19 Thread Guillaume Lelarge
On Sat, 2012-02-18 at 18:54 -0600, Aren Cambre 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 > distin

Re: [pgadmin-support] Query truncated in Server Status

2012-02-18 Thread Aren Cambre
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

[pgadmin-support] Query truncated in Server Status

2012-02-18 Thread Aren Cambre
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