Hi!
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.
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.
Btw, any ideas on the build error in the previous mail? I have no ideas
what to do to "make it happen" :)
Regards,
Miha
Dave Page wrote:
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Miha Radej
Sent: 28 March 2006 08:27
To: pgadmin-hackers
Subject: Re: [pgadmin-hackers] view data causes pgadmin to hang or die
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:
Does the query tool display it properly if you increase the "Max
characters per column" option under File->Options->Query so it is large
enough to hold the data?
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
