SEO

#1 (**permalink**) 04-17-2008, 06:01 PM

On 29/3/06 17:08, "Miha Radej" <miha.radej@siix.com> wrote:

>
>
>
> Dave Page wrote:
>>> >> -----Original Message-----
>>> >> Hmm, yes, sorry, I tried it but forgot to report it. I tried
>>> >> increasing
>>> >> the column size to various values, from very small to large, a few
>>> >> hundred kilobytes. Crash/hang still there.
>> >
>> > Still there? I thought you said it was working in the query tool?
>
> Still there in "View Data". I am too tired I guess to think and type
> straight

>
> If I (try to) summarize: it is only "View Data" which causes the
> crash/hang. Doing a "select *" on the table in question in the Query
> Tool works and displays the data OK, although I seem to not be able to
> pass the limit of 101 displayed tuples, regardless of the settings.
>
> So my problem is why does using "View Data" (to display all data in a
> table) cause pgAdmin to crash/hang. It seems to happen when pgAdmin
> tries to display the data it had received from the DB. I've just
> compiled the latest revision and it is the same.
>
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.

Regards, Dave

#2 (**permalink**) 04-17-2008, 06:01 PM

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".

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

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.

Thank you for your time and help!

Regards,
Miha

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: view data causes pgadmin to hang or die