Re: [pgAdmin][RM5157] Default sort order at start in view table databy primary key by default
| От | Dave Page |
|---|---|
| Тема | Re: [pgAdmin][RM5157] Default sort order at start in view table databy primary key by default |
| Дата | |
| Msg-id | CA+OCxoybvpAorf3dCbUYXnLADvk+WVts1DxVaOmQyNEdRugG=w@mail.gmail.com обсуждение исходный текст |
| Ответ на | [pgAdmin][RM5157] Default sort order at start in view table data byprimary key by default (navnath gadakh <navnath.gadakh@enterprisedb.com>) |
| Ответы |
Re: [pgAdmin][RM5157] Default sort order at start in view table databy primary key by default
|
| Список | pgadmin-hackers |
On Thu, Apr 16, 2020 at 12:08 PM navnath gadakh <navnath.gadakh@enterprisedb.com> wrote:
Hi Dave/Team,This patch is related to the default sort order for the view table data. In pgAdminIII default ordering is by primary key and this is not working in pgAdminIV.I have attached the patch with the back end code.Please review it.Question: There is one suggestion on https://redmine.postgresql.org/issues/5157 about to put a checkbox in the configuration for this behavior.Do I need to implement that really? I yes, Is preferences a good place for that? / Suggestions?
I think we should make this optional, and yes, Preferences is a good place. The reason is that sorting data is not without cost - at the very least it will require use of an index to access what may be the whole table.
Dave Page
VP & Chief Architect, Database Infrastructure
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
VP & Chief Architect, Database Infrastructure
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
В списке pgadmin-hackers по дате отправления: