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

[Jim Busser]

On 2011-09-08, at 4:13 AM, Karsten Hilbert 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 ;

??

-- Jim