Re: view data causes pgadmin to hang or die

> -----Original Message-----
> From: Miha Radej [mailto:miha.radej@siix.com]
> Sent: 30 March 2006 08:07
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] view data causes pgadmin to hang or die
>
> Hi!
>
> Dave Page wrote:
> > So, just to be clear, the query tool will display the data
> correctly,
> > even if the maximum column length option is increased to
> accommodate the
> > largest data item?
> >
> > I want to be clear about this because in SVN trunk now, the
> grid code is
> > shared between the two tools so both /should/ fail, but the column
> > length option might be masking the problem in the query tool.
>
> I've checked out a fresh copy from SVN today. I've set "Max rows to
> retrieve" to 0, "Max. characters per column" to 700000. "View data"
> hangs/crashes, as does "Query tool".

OK, that's what I was expecting to happen.

> A few days ago when I hadn't had the latest build the "Query
> tool" had
> worked. But that may have been due to the fact that no matter
> what I had
> set for "Max rows to retrieve", I'd only get 101 rows. I now get
> everything, including the crash :)

Well, the query tool was recently changed to use the same grid control
as the view data tool, however even if you had a post-change version I
think the problem was being masked by the auto-truncation of the results
that only happens in the query tool.

> And what is even more strange, the original table (I've been playing
> with copies of it) grew for a few records and now everything
> works fine
> - both "View data" and "Query tool". I don't know what to make of it.

Now that's really weird. I don't suppose you still have a copy of the
data prior to the changes do you? Is it something you can let me see?

> Thank you for your time and help!

You're welcome.

Regards, Dave.