From: Michael Glaesemann <grzm@seespotcode.net>
To: Ronald Rojas <ronald.rojas@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [NOVICE] alter table table add column
Date: Tue, 31 Jul 2007 00:56:11 -0500
Message-ID: <3345E320-08CF-465E-93AC-DAFBD59AA35C@seespotcode.net> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: grzm@seespotcode.net, ronald.rojas@gmail.com, pgsql-general@postgresql.org
Subject: Re: [NOVICE] alter table table add column
In-Reply-To: <3345E320-08CF-465E-93AC-DAFBD59AA35C@seespotcode.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox