Skip site navigation (1) Skip section navigation (2)

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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, "onur(dot)oguzel" <onur(dot)oguzel(at)gmail(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Create Table Dialog: Change Column after creation/Reorder Columns
Date: 2010-06-21 20:39:22
Message-ID: AANLkTikL7Cs0jTGjV49FegHl1Y4rKEkPzX2ithes90FB@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
On Mon, Jun 21, 2010 at 10:34 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> On Mon, Jun 21, 2010 at 4:18 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>
>> I think that's an acceptable solution, provided it works well. *IFF*
>> it is very very very very clear to the user that this is what happens
>> (extra warning dialog(s), please!). A lot of people have tables small
>> enough that this is not a problem.
>>
>> And remember that it's not quite as trivial as one would initially
>> think - you still need to recreate all indexes and foreign keys and
>> sutff. But it's certainly doable.
>
> And views and functions and rules and triggers.... Just handling that
> lot would be a significant amount of code.

Well, dependency trakcing should help with that -. at least with
identifying when it can't be done. But yes, it may take a lot of code.


> My main concerns though, are the space requirements for a large table
> and the locking that would be required. This is not something you
> would attempt on a large or busy table unless you were certifiably
> insane.
>

Agreed - thus the warning requirement.


-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

Responses

pgadmin-hackers by date

Next:From: Onur GUZELDate: 2010-06-22 12:14:36
Subject: Re: Create Table Dialog: Change Column after creation/Reorder Columns
Previous:From: Dave PageDate: 2010-06-21 20:34:32
Subject: Re: Create Table Dialog: Change Column after creation/Reorder Columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group