From: Andrew - Supernews <andrew+nonews@supernews.com>
Subject: Re: Building a database from a flat file
Date: Sun, 06 Mar 2005 19:58:17 -0000
Organization: http://www.supernews.com - all your nntp are belong to us
Message-ID: <slrnd2mo6p.2quv.andrew+nonews@trinity.supernews.net>
References: <1109808921.12430.75.camel@boomerang.ran.sandia.gov>
	<42272D27.4030900@logix-tt.com>
Reply-To: andrew@supernews.com
User-Agent: slrn/0.9.8.0 (FreeBSD)
Lines: 19
To: pgsql-sql@postgresql.org

On 2005-03-03, Markus Schaber <schabi@logix-tt.com> wrote:
> - Create the new date in another schema, and then simply rename those
> two schemas for "switch over"

This kind of thing looks superficially attractive but it has some serious
problems if you try and do it while there is other database activity.
Specifically, cached plans for functions and prepared statements will not
be invalidated by the rename, and will still refer to the old tables, so
you may have inconsistent results.

> - Have two different set of tables (maybe two identical schemas), and
> let your application work on a set of views. Then you can change the
> views via "create or replace view" for switch over.

Same problem applies here.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services