Re: Create Table Dialog: Change Column after creation/Reorder Columns

On Sun, Jun 20, 2010 at 4:46 PM, Guillaume Lelarge
<guillaume@lelarge.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