Re: [NOVICE] alter table table add column

[Ronald Rojas <ronald(dot)rojas(at)gmail(dot)com>]

Oh yes you have a good point. But then I will still have to test insert and update on views.

Thanks a lot michael!

On Tue, 2007-07-31 at 00:56 -0500, Michael Glaesemann wrote:
> On Jul 31, 2007, at 0:23 , Ronald Rojas wrote:
>
> > Yes I know that procedure but I would like to insert in between  
> > because I have at third party software that will call the said  
> > schema and one of its dependencies with the mapping is it should  
> > have the correct order with what the receiving end will be use for  
> > the mapping. And in this case, I can't modify the receiving  
> > structure (third-party) and the tables that I will be using is in  
> > on production state. So would only mean that I have to schedule a  
> > very fast maintenance, probably 5 to 10 secs just to re-initialize  
> > the tables.
>
> Another option would be to use views to change the column order,  
> which would work for selects. I believe you could create rules for  
> insert and update as well, if necessary. Perhaps this would be a  
> solution to your problem.
>
> Michael Glaesemann
> grzm seespotcode net

==================================================================================================
Ronald Rojas
Systems Administrator
Linux Registered  User #427229
==================================================================================================

Arnold's Laws of Documentation:
	(1) If it should exist, it doesn't.
	(2) If it does exist, it's out of date.
	(3) Only documentation for useless programs transcends the
	    first two laws.