Re: Changed default ordering in tables

On Tue, Jul 26, 2011 at 9:53 PM, Erwin Brandstetter
<brandstetter@falter.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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company