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

Re: Changed default ordering in tables

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Changed default ordering in tables
Date: 2011-07-29 02:57:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
On 26.07.2011 23:20, Dave Page wrote:
> 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?

Yeah, me. ;) On another Win XP machine ...


Erwin Brandstetter

In response to


pgadmin-hackers by date

Next:From: Erwin BrandstetterDate: 2011-07-29 05:10:08
Subject: Re: Changed default ordering in tables
Previous:From: Luis OchoaDate: 2011-07-29 01:59:52
Subject: Database Designer report at 28/07/2001

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