Dave Page wrote:
> Sent to the list owner in error...
>
> ------------------------------------------------------------------------
> *From:* Belbin, Peter [mailto:PBelbin@McLeodUSA.com]
> *Sent:* 29 August 2005 19:09
> *To:* 'pgadmin-support-owner@postgresql.org'
> *Subject:* problem pasting text into a column in 'view data' window
>
> Hi there,
>
> Many thanks, and congratulations to your work thus far. I use
> pgAdmin-III pretty much on a daily basis, and it's done a great job
> of putting a nice face on postgresql. I would probably not choose
> to use postgresql if it weren't for there being a decent gui with
> which to interact through.
>
> As you may have guessed however, I've recently become aware of a
> problem.
>
> I'm using pgAdmin-III 1.2.2 on Windows XP, and pasting a large-ish
> amount of text from the copy/paste buffer into a 'text' column, and
> find that the text is truncated at around 33K in size.
>
> The text I'm wanting to paste is around 100K in size.
>
> 4 things I have noticed:
>
> a) if you go to the end of the column, and try adding text, it won't
> let me.
>
> b) if I go to the beginning of the column, and add text, it will let me.
>
> c) having done b) quite a few times (making text of around 1MB in
> size) and then moving from one row to another, the CPU utilization
> jumped up to around 90% and the app never came back. I'm not sure
> whether it sent anything to the db or not.
>
> d) even after having gotten the larger amount of text (say 100K)
> into the buffer a piece at a time by pasting some dummy text
> repeatedly, if I then add / replace this with the text I really want
> in there, it still gets truncated at the 33K mark.
>
> Would someone with their finger on the pulse of pgAdmin-III code be
> able to fix this please?
We don't have limits on this (AFAIK), so I'm afraid it's a restriction
of the underlying control. I'm afraid you're stressing the goal of the
table editor beyond its reasonable limits, don't have a solution at hand
for you (at least not in pgAdmin)
Regards,
Andreas