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
Agreed - thus the warning requirement.
In response to
pgadmin-hackers by date
|Next:||From: Onur GUZEL||Date: 2010-06-22 12:14:36|
|Subject: Re: Create Table Dialog: Change Column after creation/Reorder
|Previous:||From: Dave Page||Date: 2010-06-21 20:34:32|
|Subject: Re: Create Table Dialog: Change Column after creation/Reorder Columns|