Thread: Pgadmin data output string disappear when reach 3278 length

<ul><li>Ver 1.16.0(Sep 7 2012; rev REL-1_16_0)  <br /><li>Windows XP Pro, SP3 <br /> <li>Steps required to reproduce
theproblem:<br /></ul><p>Execute <br />select array_agg('M'::TEXT) <br />from (select generate_series(1,1637)) as
atable;<p><p>Sowe get string {M,M ... ,M} <b>3276 </b>length. It's correctly displaying at data output
pane.<p>Execute<br/>select array_agg('M'::TEXT) <br />from (select generate_series(1,1638)) as atable;<br /> Data
outputis empty. But if we will copy value from data output and paste it anywhere else, we will get string {M,M ... ,M}
<b>3278</b>length.<p>Is it a bug or a known restriction?<p><p>P.S: sorry for poor English.<br /> 

On Wed, 2012-10-03 at 17:32 +0400, Alex Bozhenko wrote:
>    - Ver 1.16.0(Sep 7 2012; rev REL-1_16_0)
>    - Windows XP Pro, SP3
> 
>    - Steps required to reproduce the problem:
> 
> Execute
> select array_agg('M'::TEXT)
> from (select generate_series(1,1637)) as atable;
> 
> So we get string {M,M ... ,M} *3276 *length. It's correctly displaying at
> data output pane.
> 
> Execute
> select array_agg('M'::TEXT)
> from (select generate_series(1,1638)) as atable;
> Data output is empty. But if we will copy value from data output and paste
> it anywhere else, we will get string {M,M ... ,M} *3278 *length.
> 

Doesn't happen to me.

> Is it a bug or a known restriction?
> 

Well, it's known that long strings are poorly displayed. Poorly as in
not at all. I would call that a bug in wxWidgets. We don't have a
workaround though.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com