search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.53k stars 658 forks source link

Foreign Table create script puts columns in alphabetical order instead of the actual order of the columns as the table was originally created (RM #2318) #1100

Closed dpage closed 2 years ago

dpage commented 7 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/2318 Originally created by Shira Bezalel at 2017-04-04 21:24:26 UTC.

If you click on the SQL tab or select 'CREATE Script' of a Foreign Table, it will order the columns in alphabetical order instead of the actual order of the columns as the table was originally created. Note that the columns listed in the SELECT statement part of the Foreign Table definition do not get reordered.

Version1.3 CopyrightCopyright 2013 - 2017, The pgAdmin Development Team Python Version2.7.12 (v2.7.12:d33e0cf91556, Jun 27 2016, 15:19:22) [MSC v.1500 32 bit (Intel)] Flask Version0.11.1 Application ModeDesktop Current Userpgadmin4@pgadmin.org

dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2318#note-1 Originally created by Dave Page at 2017-04-05 11:38:22 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 1.5
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2318#note-2 Originally created by Khushboo Vashi at 2017-04-14 04:21:18 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Khushboo Vashi
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2318#note-3 Originally created by Khushboo Vashi at 2017-04-14 05:06:36 UTC.

Patch submitted.

https://www.postgresql.org/message-id/CAFOhELe30NSfgwU41q9mR_k4edjufgPoR3bpSih-1CE7UVH5rQ@mail.gmail.com

dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2318#note-4 Originally created by Khushboo Vashi at 2017-04-18 13:37:34 UTC.

Applied in changeset commit:8d6add13c06bbd92a581a6044b2efc92cfa29df0.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2318#note-5 Originally created by Fahar Abbas at 2017-05-15 05:15:46 UTC.

Issue resolved in Windows 2012 R2 64 with Python 2.7.12 and Ubuntu 14.04 Linux 64 with Python 3.4. Commit ID:

commit 0e7efc0cf8709ed3e1c0e4fc17a29707a79b1bbc

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2318#note-6 Originally created by Fahar Abbas at 2018-01-09 05:34:40 UTC.

Redmine ticket header update:

Name Old Value New Value
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.