pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Aaron Bono <postgresql@aranya.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: i have table
Date: Mon, 9 Oct 2006 11:01:17 -0500
Message-ID: <bf05e51c0610090901p6d2562acwfff1b200c086ffa9@mail.gmail.com> (raw)
In-Reply-To: <20061005152952.GA8826@phlogiston.dyndns.org>
References: <A70AE049E81A6A40879D5DC0AC8C38C9073DCD8F@venus.infics.com>
	<45237D6E.1030601@logix-tt.com>
	<4523C3E2.4010300@myemma.com>
	<bf05e51c0610040754o101408c2y8a743697b9ceee4@mail.gmail.com>
	<4523D51F.4070208@myemma.com>
	<bf05e51c0610040920x329f3c79u9fdaed0d490f8bb1@mail.gmail.com>
	<20061005152952.GA8826@phlogiston.dyndns.org>

On 10/5/06, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
>
> On Wed, Oct 04, 2006 at 11:20:07AM -0500, Aaron Bono wrote:
> >
> > So do it as needed and convert your application slowly.
>
> You don't even need to do that.
>
> ALTER TABLE tablename RENAME TO tablename_real;
>
> CREATE VIEW tablename [&c.]
>
> Now the view looks to the application just like the old table.  If
> you want to insert &c., you put some rules there.



If you do this you need to make the view updateable or
inserts/updates/deletes will break.

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

view thread (19+ messages)  latest in thread

Message-ID: <bf05e51c0610090901p6d2562acwfff1b200c086ffa9@mail.gmail.com>
Permalink:  ../bf05e51c0610090901p6d2562acwfff1b200c086ffa9@mail.gmail.com/
Also on:    postgresql.org/message-id/bf05e51c0610090901p6d2562acwfff1b200c086ffa9@mail.gmail.com

 · 

reply
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: postgresql@aranya.com, ajs@crankycanuck.ca
  Subject: Re: i have table
  In-Reply-To: <bf05e51c0610090901p6d2562acwfff1b200c086ffa9@mail.gmail.com>

* 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