Skip site navigation (1) Skip section navigation (2)

Re: Changed default ordering in tables

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Changed default ordering in tables
Date: 2011-07-26 21:20:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
On Tue, Jul 26, 2011 at 9:53 PM, Erwin Brandstetter
<brandstetter(at)falter(dot)at> wrote:
> That may be the key here. When I open the simple test table from above in
> v1.14 I get descending order. On opening the Sort/Filter dialog it see an
> explicit ORDER BY test_id DESCENDING - which I did not set.
> Once I delete that, the sort order falls back to ascending - as it should to
> begin with.
> However, after reopening the table explicit descending order is back.

I see the same... except it's defaulting to ASC.

> Interesting that you cannot reproduce the effect. Ar you on Apple?
> I am tested with all combinations of pgAdmin 1.12 & 1.14 Beta 3 on Win XP
> Pro and postgres 9.0.4 and 8.4.8 on Debian Squeeze.

Tested on Mac and Windows 7.

> Playing with the new Features "View Data" .. "View top / last 100 rows" has
> no lasting side effects on this problem.

Very odd. Anyone else able to reproduce this?

Dave Page
Twitter: @pgsnake

EnterpriseDB UK:
The Enterprise PostgreSQL Company

In response to


pgadmin-hackers by date

Next:From: Dave PageDate: 2011-07-26 21:33:33
Subject: pgAdmin III commit: More wx2.9 compatibility. Almost there now!
Previous:From: Erwin BrandstetterDate: 2011-07-26 20:53:54
Subject: Re: Changed default ordering in tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group