From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | onur(dot)oguzel(at)gmail(dot)com, pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: Create Table Dialog: Change Column after creation/Reorder Columns |
Date: | 2010-06-20 20:52:02 |
Message-ID: | AANLkTimfv33-99dIYbILen0rLngt-eb-q4AdbrjXs9c5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
On Sun, Jun 20, 2010 at 4:46 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
> Le 20/06/2010 22:00, Onur GUZEL a écrit :
>> [...]
>> I want to contribute to pgadmin project, is it ok to start with
>> http://code.pgadmin.org/trac/ticket/90 ( Create Table Dialog: Change
>> Column after creation/Reorder Columns )
>>
>
> The aim of the ticket is to allow the reordering of columns in a table.
> This is not a functionality of PostgreSQL. So, you'll have to think a
> bit on how to do this with pgAdmin. You'll need to find a way to get all
> the metadatas and the datas of the table, to create a new one, nearly
> identical (nearly because the order of the columns will be changed, and
> only that).
The body of the ticket actually covers both the pre-creation, and
post-creation cases. Post-creation is essentially impossible to
support without changes in PostgreSQL.
> IOW, the UI needed is just a snap to do (a couple of buttons to bring up
> or down the selected column), but the underlying work to make it happen
> could be quite hard.
That's all that's needed for pre-creation reordering, and should be
quite straightforward... but... I am intending to redesign the table
dialogue for 1.14, so any work on this might go to waste (but, I
cannot guarantee I'll have the resources, so it may not!).
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | pgAdmin Trac | 2010-06-20 20:54:45 | Re: [pgAdmin III] #52: Support for drag and drop in the object's browser |
Previous Message | Guillaume Lelarge | 2010-06-20 20:46:46 | Re: Create Table Dialog: Change Column after creation/Reorder Columns |