Re: [pgadmin-support] Text column with large amounts of data

From: "Belbin, Peter" <PBelbin(at)McLeodUSA(dot)com>
To: 'Dave Page' <dpage(at)postgresql(dot)org>, Kieran McCusker <kieran(dot)mccusker(at)kwest(dot)info>
Cc: pgadmin-support(at)postgresql(dot)org, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Text column with large amounts of data
Date: 2008-01-07 17:24:15
Message-ID: 584E52880858414885349F77E04B677C010C6AC2@TXHOUEXCH03.mcld.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

Sounds good to me. This has been a bug-bear for me for a long time too.

-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Dave Page
Sent: Monday, January 07, 2008 10:11 AM
To: Kieran McCusker
Cc: pgadmin-support(at)postgresql(dot)org; pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Text column with large amounts of data

On 04/01/2008, Dave Page <dpage(at)postgresql(dot)org> wrote:
> On 04/01/2008, Kieran McCusker <kieran(dot)mccusker(at)kwest(dot)info> wrote:
> > Dave
> >
> > Does Max characters per column work in 1.8.1? Whatever I set the limit
does
> > not seem to affect text fields?
>
> It should do, but maybe it got broken :-(. I'll add it to my todo list.

Yes, it did get broken quite a while back. The attached patch will fix
it again, but this is potentially problematic because

a) it's a non-obvious change in behaviour over last last few releases

b) the default setting means it will be turned on (because the default
value is 256, not zero).

c) we don't know if any data is actually truncated until the cell is
rendered, meaning we cannot popup a warning at query completion time.

The safest option seems to me to be to apply the patch to trunk, and
change the default to zero, using a different config option to ensure
we don't pickup the old default form prior installations.

Thoughts anyone?

/D

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

NOTICE: This electronic mail transmission may contain confidential
information and is intended only for the person(s) named. Any use, copying
or disclosure by any other person is strictly prohibited. If you have
received this transmission in error, please notify the sender via e-mail.

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2008-01-07 21:53:54 SVN Commit by dpage: r6973 - in trunk/pgadmin3: . pgadmin/debugger
Previous Message Dave Page 2008-01-07 16:11:23 Re: [pgadmin-support] Text column with large amounts of data

Browse pgadmin-support by date

  From Date Subject
Next Message Bomken Basar 2008-01-07 20:48:47 database upgrade. Urgent!!!
Previous Message Dave Page 2008-01-07 16:11:23 Re: [pgadmin-support] Text column with large amounts of data