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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Onur GUZEL | 2010-06-22 12:14:36 | Re: Create Table Dialog: Change Column after creation/Reorder Columns |
Previous Message | Dave Page | 2010-06-21 20:34:32 | Re: Create Table Dialog: Change Column after creation/Reorder Columns |