Re: Concat truncates at 257 characters

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Concat truncates at 257 characters
Date: 2013-11-26 00:10:45
Message-ID: 1385424645388-5780258.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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" &lt;

> pierce@

> &gt; 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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message libraryifet 2013-11-26 06:54:22 BUG #8631: invalid page header
Previous Message John R Pierce 2013-11-26 00:03:43 Re: Concat truncates at 257 characters