1. If we have multiple Primary keys, then we should include all the keys into the Order by clause.
2. In the Preferences dialog, please put this option in the Query Tool > Options instead of Result Grid and also change the Label.
3. Please optimize the code, as I can see objectname.sql file is being used in else condition also, which is not required. Based on the parameter setting, Just one call of that sql is enough.
Please find the modified patch with an option in Preferences for data sorting by the primary key. Also, the previous patch was not working with table has no primary key.
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.
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