Skip site navigation (1) Skip section navigation (2)

Re: view data causes pgadmin to hang or die

From: Miha Radej <miha(dot)radej(at)siix(dot)com>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: view data causes pgadmin to hang or die
Date: 2006-03-29 13:41:52
Message-ID: 442A8EA0.6070603@siix.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi!

Dave Page wrote:
>> Now that you mention it... I've played around a bit and I've observed 
>> the following.
>>
>> The "View Data" function: crashes or hangs regardless of any settings.
>>
>> The Query tool: it wasn't a problem. I said "select * from 
>> table;" and 
>> it happily displayed the results. The result set returned 
>> more than 100 
>> rows (the limit set in options) so the query tool asked me if 
>> I wanted 
>> to display everything. I said "Yes" and of 204 records only 101 got 
>> displayed. I then increased the max number of returned rows 
>> to 500 and 
>> again I only got 101 row.
> 
> OK, but what if you increase the max column size as I suggested? If it's
> a grid problem, the data truncation in the query tool might be masking
> it.

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.

>> The "View Data" works OK on any other table I have so I'm 
>> really baffled 
>> by this. The query tool however limits the display to 101 tuples, 
>> regardless of the row limit settings.
> 
> Are those tables of similar structure, with similarly long data items?

The closest possible. I am making some copies, where I'll reduce the row 
set and increase them... I will report back what happens then, however I 
won't be able to do that today.

>> Btw, any ideas on the build error in the previous mail? I 
>> have no ideas 
>> what to do to "make it happen" :)
> 
> Sorry, you'll have to remind me what the problem is.

Of course :)

I wanted to see if the problem is present in the latest code from SVN. I 
can compile revision 5056 just fine, but building revision 5057 yields:

if g++ -DHAVE_CONFIG_H -I. -I. -I.. 
-DDATA_DIR=\"/usr/local/pgadmin-svn/share/pgadmin3/\" -Wall 
-Wno-non-virtual-dtor -I../src/include -I../src/agent/include 
-I../src/slony/include -I/usr/include/pgsql -DSSL 
-I/usr/lib/wx/include/gtk2-unicode-release-2.6 -I/usr/include/wx-2.6 
-DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES 
-D_LARGEFILE_SOURCE=1 -DNO_GCC_PRAGMA -O2 -I/usr/include/libxml2 
-DDATA_DIR=\"/usr/local/pgadmin-svn/share/pgadmin3/\" -Wall 
-Wno-non-virtual-dtor -I../src/include -I../src/agent/include 
-I../src/slony/include  -MT ctlSQLBox.o -MD -MP -MF 
".deps/ctlSQLBox.Tpo" -c -o ctlSQLBox.o `test -f './ctl/ctlSQLBox.cpp' 
|| echo './'`./ctl/ctlSQLBox.cpp; \
then mv -f ".deps/ctlSQLBox.Tpo" ".deps/ctlSQLBox.Po"; else rm -f 
".deps/ctlSQLBox.Tpo"; exit 1; fi
make[2]: *** No rule to make target `ctl/ctlSQLGrid.cpp', needed by 
`ctlSQLGrid.o'.  Stop.
make[2]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/net/programs/pgadmin-svn/pgadmin3'
make: *** [all] Error 2

Thank you,
Miha

In response to

pgadmin-hackers by date

Next:From: svnDate: 2006-03-29 14:18:48
Subject: SVN Commit by dpage: r5058 - trunk/pgadmin3/src/ctl
Previous:From: Dave PageDate: 2006-03-29 11:58:23
Subject: Re: view data causes pgadmin to hang or die

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group