> -----Original Message----- > From: Miha Radej [mailto:[EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
