On Tue, Jul 26, 2011 at 4:47 PM, Erwin Brandstetter
> In v1.14 tables are opened with ORDER BY $pkey DESC.
> I wonder if descending order ist intended. It used to be the other way round
> and, as far as I am concerned, that was just fine in most cases.
> We have the new feature "View Data" .. "View top / last 100 rows" anyway. No
> need to change the default behavior?
The default is determined like this:
orderBy = table->GetQuotedPrimaryKey();
if (orderBy.IsEmpty() && hasOids)
orderBy = wxT("oid");
orderBy += wxT(" ASC");
orderBy += wxT(" DESC");
Essentially, we try to follow the ordering in the index.
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
pgadmin-hackers by date
|Next:||From: Erwin Brandstetter||Date: 2011-07-26 18:13:13|
|Subject: Re: Changed default ordering in tables|
|Previous:||From: Erwin Brandstetter||Date: 2011-07-26 15:47:01|
|Subject: Changed default ordering in tables|