Skip site navigation (1) Skip section navigation (2)

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

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "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 16:11:23
Message-ID: 937d27e10801070811w629d305ag89191b38bd918699@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-support
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

Attachment: collimit.diff
Description: application/octet-stream (998 bytes)

In response to

pgadmin-hackers by date

Next:From: Belbin, PeterDate: 2008-01-07 17:24:15
Subject: Re: [pgadmin-support] Text column with large amounts of data
Previous:From: svnDate: 2008-01-07 13:46:30
Subject: SVN Commit by dpage: r6972 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/schema

pgadmin-support by date

Next:From: Belbin, PeterDate: 2008-01-07 17:24:15
Subject: Re: [pgadmin-support] Text column with large amounts of data
Previous:From: Dave PageDate: 2008-01-07 09:56:14
Subject: Re: pgAdmin III Query Tool bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group