pgAdmin 4 - Foreign Table create script is sorting columns in alphabetical order instead of actual order

From: Shira Bezalel <shira(at)sfei(dot)org>
To: pgadmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin 4 - Foreign Table create script is sorting columns in alphabetical order instead of actual order
Date: 2017-02-01 18:20:47
Message-ID: CAE0KEwE0raycFJYYRzcjcC9Pi7J2KODjt1rrTv=FMtuc365psQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello pgAdmin Support,

I just noticed that if you click on the SQL tab or select 'CREATE Script'
of a Foreign Table in pgAdmin 4, it will order the columns in alphabetical
order instead of the actual order of the columns as the table was
originally created. The columns listed in the SELECT statement part of the
Foreign Table definition do not get reordered, so this is a problem if you
attempt to use this script to recreate the table because the two sets of
columns are now no longer in sync.

Version1.1
CopyrightCopyright 2013 - 2016, 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(at)pgadmin(dot)org

If you already know about this, please disregard. Just didn't see it in
Redmine.

Thank you for all your help!
Shira

Browse pgadmin-support by date

  From Date Subject
Next Message stancs3 2017-02-01 19:07:59 Re: 4th Try: pgadmin4 install, launch fail
Previous Message jbiskofski 2017-02-01 17:34:31 Re: pgadmin4 running behind nginx