Re: view data causes pgadmin to hang or die

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