Dave Page wrote:
Sent to the list owner in error...

    ------------------------------------------------------------------------
    *From:* Belbin, Peter [mailto:[EMAIL PROTECTED]
    *Sent:* 29 August 2005 19:09
    *To:* '[EMAIL PROTECTED]'
    *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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to