Re: [pgadmin-support] Default "maximum rows to retrieve" setting

2007-03-20 Thread Dave Page
John DeSoi wrote: > One of the useful things about the frontend/backend protocol > (http://www.postgresql.org/docs/8.2/interactive/protocol.html) is that > it provides a way to set a value for the maximum number of rows to > return. This avoids the major hassle of trying to analyze the query and >

Re: [pgadmin-support] Default "maximum rows to retrieve" setting

2007-03-19 Thread John DeSoi
One of the useful things about the frontend/backend protocol (http:// www.postgresql.org/docs/8.2/interactive/protocol.html) is that it provides a way to set a value for the maximum number of rows to return. This avoids the major hassle of trying to analyze the query and figure out how to ad

Re: [pgadmin-support] Default "maximum rows to retrieve" setting

2007-03-19 Thread Andy Shellam
Dave Page wrote: Ideally what I'd like is to set the default rows to retrieve to 1000, so it downloads the first 1000 rows when I open the table, and then I can choose to retrieve others if I need to. I'd love to! But I'm afraid I don't know C/C++ programming, and have never done anyth

Re: [pgadmin-support] Default "maximum rows to retrieve" setting

2007-03-19 Thread Dave Page
Andy Shellam wrote: > Hi, > > In the Preferences options, there's an option on the Query tab that says > "Maximum rows to retrieve." This is currently set to 100, but I can't > see how/where it takes effect. > > I have a table that's growing an average of 250 rows a day (currently at > 1098 rows