Re: view data causes pgadmin to hang or die

> -----Original Message-----
> From: Miha Radej [mailto:miha(dot)radej(at)siix(dot)com]
> Sent: 29 March 2006 12:28
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] 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.

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.

> 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?

> 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.

Regards, Dave