Re: [Gnumed-devel] Dropping staging tables from production databases (was offlist Re: substances data pack)

[Karsten Hilbert]

On Tue, Sep 13, 2011 at 07:45:44PM -0700, Jim Busser wrote:

> > - also suggest to drop the staging table at the end of the file
> 
> If the idea is that schema
> 
>       staging
> 
> should be left as a "handle" to which tables can be
> temporarily added -- but which should be dropped at
> completion of any production job -- then I noticed when I
> did
> 
>       SELECT * FROM pg_tables WHERE schemaname = 'staging';
> 
> that there exist, bootstrapped, tables
> 
>       staging.lab_request
>       staging.test_result
> 
> so… should a future maintenance release take care of (include):
> 
>       DROP TABLE staging.lab_request ;
>       DROP TABLE staging.test_result ;

Once there exists an importer which creates those tables as
needed they should be bootstrapped away.

Those are tables which Luke requested but never delivered on
what he suggested he might be doing with them.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346