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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
