Le 20/06/2010 22:52, Dave Page a écrit : > On Sun, Jun 20, 2010 at 4:46 PM, Guillaume Lelarge > <guilla...@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. >
I didn't think about pre-creation as in interesting thing. But thinking more about it, you're right. On the post-creation, I don't see it as impossible. I see it as hard work, but possible. >> 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!). > Yeah, I've been thinking about it too. The pre-creation patch should be easy to code. Could happen before you get to work on the redesign. Unless you want to work it now. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
