Re: view data causes pgadmin to hang or die

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Miha Radej" <miha(dot)radej(at)siix(dot)com>
Cc: "pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: view data causes pgadmin to hang or die
Date: 2006-03-30 07:16:05
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C9905@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: Miha Radej [mailto:miha(dot)radej(at)siix(dot)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.

Browse pgadmin-hackers by date

  From Date Subject
Next Message Miha Radej 2006-03-30 10:44:59 Query tool - cell content spanning across empty cells
Previous Message Miha Radej 2006-03-30 07:07:22 Re: view data causes pgadmin to hang or die