Re: view data causes pgadmin to hang or die

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: pgadmin-hackers-owner(at)postgresql(dot)org
>> [mailto:pgadmin-hackers-owner(at)postgresql(dot)org] 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
>