analytical_plot_def text := NULL;

    analytical_specimen_def text := NULL;

    provider_count_view_def text := NULL;

BEGIN

    -- Save and drop dependent objects

    BEGIN

    EXCEPTION

        WHEN undefined_table THEN NULL;

    END;

    DROP TABLE IF EXISTS analytical_stem;

    CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view LIMIT 0;

        GRANT SELECT ON TABLE provider_count_view TO bien_read;

        GRANT SELECT ON TABLE provider_count_view TO public_;

    END IF;

END;

$$;