In-Reply-To: <1185859391.28634.17.camel@localhost>
References: <1185855587.28634.6.camel@localhost>
	<7F69A56D-27E8-43EE-BD1C-AB52C042B533@seespotcode.net>
	<1185859391.28634.17.camel@localhost>
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <3345E320-08CF-465E-93AC-DAFBD59AA35C@seespotcode.net>
Cc: pgsql-general@postgresql.org
Content-Transfer-Encoding: 7bit
From: Michael Glaesemann <grzm@seespotcode.net>
Subject: Re: [NOVICE] alter table table add column
Date: Tue, 31 Jul 2007 00:56:11 -0500
To: Ronald Rojas <ronald.rojas@gmail.com>


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