view data causes pgadmin to hang or die - Mailing list pgadmin-hackers

hi!

i have a table with 204 rows of data which contain about 700k of text
alltogether. when i tried to use "view data" in the table, pgadmin
either crashes or hangs, no apparent pattern so far. in pgadmin log, set
to debug, there is nothing to indicate the problem. but according to it
(and to pgsql log) it seems pgadmin gets the data, then sends a query to
get the column names. here are the last lines from pgsql log:

DNEVNIK:  statement: SELECT oid, * FROM problematic_table ORDER BY oid ASC
DNEVNIK:  statement: SELECT n.nspname AS nspname, relname, t.typname,
nt.nspname AS typnspname, attname, attnum, COALESCE(b.oid, t.oid) AS
basetype, atthasdef, adsrc,
                CASE WHEN t.typbasetype::oid=0 THEN att.atttypmod else
t.typtypmod END AS typmod,
                CASE WHEN t.typbasetype::oid=0 THEN att.attlen else
t.typlen END AS typlen
           FROM pg_attribute att
           JOIN pg_type t ON t.oid=att.atttypid
           JOIN pg_namespace nt ON nt.oid=t.typnamespace
           JOIN pg_class c ON c.oid=attrelid
           JOIN pg_namespace n ON n.oid=relnamespace
           LEFT OUTER JOIN pg_type b ON b.oid=t.typbasetype
           LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND
adnum=attnum
          WHERE attnum > 0 AND NOT attisdropped AND attrelid=56359::oid
          ORDER BY attnum
DNEVNIK:  unexpected EOF on client connection

dnevnik = log

i'm guessing pgadmin gets the data, asks for the column names and then
has problems displaying the data.

if i copy&paste the queries into the query tool, it works without
problems (on all pgadmin versions i've tried this on), the data displays
very fast.

i am using pgadmin3, compiled from cvs, revision 5056, on opensuse 10.0.
the same happened with pgadmin3 1.4.x for debian (used on kubuntu 5.10)
and revision 5056 built on the same kubuntu.

i tried building the latest revision (5057) but it fails with the
following error, on both kubuntu and suse:

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

i cannot provide the table structure or data unfortunately but if you
need any more information, i'd be happy to try to provide it.

regards,
Miha