Re: Concat truncates at 257 characters

From: Patrick Lademan <mjfrog14(at)gmail(dot)com>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Concat truncates at 257 characters
Date: 2013-11-26 16:46:47
Message-ID: CADMm_6ChD3oJAMGxot4vkqYhjctBsfucB=JcyFpSNRDU64zR+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

This appears to be a new behavior in pgAdmin between versions 9.2 and 9.3
because I have existing unit tests with 516 character strings that I copy
and pasted from the pgAdmin result column.

How can I configure pgAdmin to display more than 257 characters in a result
column?

On Mon, Nov 25, 2013 at 7:10 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:

> Patrick Lademan wrote
> > What is difference between pgadmin and psql that would cause one to
> > truncate?
> > On Nov 25, 2013 6:18 PM, "John R Pierce" <
>
> > pierce@
>
> > > wrote:
> >
> >> On 11/25/2013 3:09 PM, Patrick Lademan wrote:
> >>
> >>> The following simple examples all truncate at 257 characters and add a
> >>> trailing " (...)".
> >>>
> >>> select rpad('', 200, 'A') || rpad('', 200, 'B');
> >>>
> >>
> >> hmmm?
> >>
> >> $ psql scratch
> >> ....
> >> scratch=# select rpad('', 200, 'A') || rpad('', 200, 'B');
> >>
> >> ?column?
> >>
> >>
> >> ------------------------------------------------------------
> >> ------------------------------------------------------------------------
> >> ------------------------------------------------------------
> >> ------------------------------------------------------------------------
> >> ------------------------------------------------------------
> >> ------------------------------------------------------------------------
> >> ------
> >> AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
> >> AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
> >> AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
> >> AAAAAAAAABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
> >> BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
> >> BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
> >> BBBBB
> >> (1 row)
> >>
> >>
> >> not here.
>
> What usage pattern, specifically, are you implementing (not that it will
> mean much to me personally since my use of both pgAdmin and psql is
> minimal)?
>
> pgAdmin's design premise is that the output it generates will be consumed
> by
> a human during routine administrative tasks. psql provides that level of
> interaction plus the ability to configure its output to be processed
> consistently by other software.
>
> I was actually somewhat surprised that you could even use pgAdmin given the
> level of automation you describe but maybe I assumed too much or pgAdmin
> can
> do more than I imagined - though really psql was designed to meet your
> automation needs pgAdmin mostly is not even if it has some conveniences.
>
> That said there should be (ideally, not sure in reality) some way to
> disable
> that behavior and force pgAdmin to output full text contents (w/o
> human-friendly truncation).
>
> David J.
>
>
>
>
>
>
>
>
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Concat-truncates-at-257-characters-tp5780244p5780258.html
> Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-11-26 16:50:09 Re: BUG #8628: md5 security hole
Previous Message David Johnston 2013-11-26 15:23:20 Re: BUG #8629: Strange resultset when using CTE or a subselect