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.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz