Le 13/08/2010 02:07, Dave Page a écrit : > On Thu, Aug 12, 2010 at 11:08 PM, Matt Janssen <[email protected]> wrote: >>> "Top" just means the first 100 returned by an unordered select query. >>> They're actually in a completely arbitrary order, as that's how >>> Postgres stores them, so "bottom" doesn't really make any sense. We >>> don't make any attempt to order, as we have no idea what makes sense >>> for any particular table - you can specify your own ordering in the >>> filter/sort dialog of course. >> >> Not to argue since I'm pretty novice with pgAdmin, but every time I open a >> table with "View Top 100 Rows" the filter/sort options are already set to >> PRIMARY KEY Ascending. Can we offer the reverse behavior? > > Hmm, that must have been snuck in when I wasn't looking :-p > > I guess we could offer that in reverse. >
Steffen Kuhn worked on a patch for this request. I commited it tonight. See http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commit;h=527e2972bfff8cb8f16db6155980760c6810496b for the actual patch. It adds a "View Last X lines" menu item everywhere there is a "View Top X lines". Thanks for the request, Matt. And thanks for the patch, Steffen. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
