DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:subject:from:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer;
	b=o4baRu60wHtIdIQx83tvIM2s/BeR5tIZ32tueatwctrkQQu8Hv7po3ESmLCMctJyYf73V8LxaDlY60BzTsSQ7wwlRgVn8tl2lbxsuqLfKNmeR4lMdaU+S+w8LJbmPluLmgbIA3Ff+PVMoIPFxbagu4P9ocOLVBUvQGR1C9PHVho=
Subject: Re: [NOVICE] alter table table add column
From: Ronald Rojas <ronald.rojas@gmail.com>
To: Michael Glaesemann <grzm@seespotcode.net>
Cc: pgsql-general@postgresql.org
In-Reply-To: <3345E320-08CF-465E-93AC-DAFBD59AA35C@seespotcode.net>
References: <1185855587.28634.6.camel@localhost>
	<7F69A56D-27E8-43EE-BD1C-AB52C042B533@seespotcode.net>
	<1185859391.28634.17.camel@localhost>
	<3345E320-08CF-465E-93AC-DAFBD59AA35C@seespotcode.net>
Content-Type: multipart/alternative; boundary="=-/c5FOEyVJ5n9YLrn66A0"
Date: Tue, 31 Jul 2007 14:37:28 +0800
Message-Id: <1185863848.28634.19.camel@localhost>
Mime-Version: 1.0


--=-/c5FOEyVJ5n9YLrn66A0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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.


--=-/c5FOEyVJ5n9YLrn66A0
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.14.1">
</HEAD>
<BODY>
Oh yes you have a good point. But then I will still have to test insert and update on views.<BR>
<BR>
Thanks a lot michael!<BR>
<BR>
On Tue, 2007-07-31 at 00:56 -0500, Michael Glaesemann wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">On Jul 31, 2007, at 0:23 , Ronald Rojas wrote:</FONT>

<FONT COLOR="#000000">&gt; Yes I know that procedure but I would like to insert in between  </FONT>
<FONT COLOR="#000000">&gt; because I have at third party software that will call the said  </FONT>
<FONT COLOR="#000000">&gt; schema and one of its dependencies with the mapping is it should  </FONT>
<FONT COLOR="#000000">&gt; have the correct order with what the receiving end will be use for  </FONT>
<FONT COLOR="#000000">&gt; the mapping. And in this case, I can't modify the receiving  </FONT>
<FONT COLOR="#000000">&gt; structure (third-party) and the tables that I will be using is in  </FONT>
<FONT COLOR="#000000">&gt; on production state. So would only mean that I have to schedule a  </FONT>
<FONT COLOR="#000000">&gt; very fast maintenance, probably 5 to 10 secs just to re-initialize  </FONT>
<FONT COLOR="#000000">&gt; the tables.</FONT>

<FONT COLOR="#000000">Another option would be to use views to change the column order,  </FONT>
<FONT COLOR="#000000">which would work for selects. I believe you could create rules for  </FONT>
<FONT COLOR="#000000">insert and update as well, if necessary. Perhaps this would be a  </FONT>
<FONT COLOR="#000000">solution to your problem.</FONT>

<FONT COLOR="#000000">Michael Glaesemann</FONT>
<FONT COLOR="#000000">grzm seespotcode net</FONT>


</PRE>
</BLOCKQUOTE>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<PRE>
==================================================================================================
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.


</PRE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-/c5FOEyVJ5n9YLrn66A0--