Project

General

Profile

« Previous | Next » 

Revision 7631

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: sync_analytical_stem_to_view(): Also drop and re-create new dependent views analytical_plot, analytical_specimen

View differences:

vegbien.sql
1021 1021 
    AS $$
1022 1022 
DECLARE
1023 1023 
    analytical_aggregate_view_def text := NULL;
1024 
    analytical_plot_def text := NULL;
1025 
    analytical_specimen_def text := NULL;
1024 1026 
    provider_count_view_def text := NULL;
1025 1027 
BEGIN
1026 1028 
    -- Save and drop dependent objects
......
1033 1035 
        WHEN undefined_table THEN NULL;
1034 1036 
    END;
1035 1037 
    BEGIN
1038 
        analytical_plot_def :=
1039 
            'CREATE OR REPLACE VIEW analytical_plot AS '
1040 
            ||pg_get_viewdef('analytical_plot');
1041 
        DROP VIEW analytical_plot;
1042 
    EXCEPTION
1043 
        WHEN undefined_table THEN NULL;
1044 
    END;
1045 
    BEGIN
1046 
        analytical_specimen_def :=
1047 
            'CREATE OR REPLACE VIEW analytical_specimen AS '
1048 
            ||pg_get_viewdef('analytical_specimen');
1049 
        DROP VIEW analytical_specimen;
1050 
    EXCEPTION
1051 
        WHEN undefined_table THEN NULL;
1052 
    END;
1053 
    BEGIN
1036 1054 
        provider_count_view_def :=
1037 1055 
            'CREATE OR REPLACE VIEW provider_count_view AS '
1038 1056 
            ||pg_get_viewdef('provider_count_view');
......
1061 1079 
        EXECUTE analytical_aggregate_view_def;
1062 1080 
        GRANT SELECT ON TABLE analytical_aggregate_view TO bien_read;
1063 1081 
    END IF;
1082 
    IF analytical_plot_def IS NOT NULL THEN
1083 
        EXECUTE analytical_plot_def;
1084 
        GRANT SELECT ON TABLE analytical_plot TO bien_read;
1085 
    END IF;
1086 
    IF analytical_specimen_def IS NOT NULL THEN
1087 
        EXECUTE analytical_specimen_def;
1088 
        GRANT SELECT ON TABLE analytical_specimen TO bien_read;
1089 
    END IF;
1064 1090 
    IF provider_count_view_def IS NOT NULL THEN
1065 1091 
        EXECUTE provider_count_view_def;
1066 1092 
        GRANT SELECT ON TABLE provider_count_view TO bien_read;

Also available in: Unified diff