Untitled

ERROR:  syntax error at or near "NOT"
LINE 1: CREATE MATERIALIZED VIEW IF NOT EXISTS chw_hierarchy AS
                                    ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS chw_hierarchy_uuid ON chw_...
                               ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS chw_hierarchy_parent_uuid ON chw_...
                        ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS chw_hierarchy_parent_parent_uuid ...
                        ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS chw_hierarchy_supervisor_uuid ON ...
                        ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
ERROR:  relation "chw_hierarchy" does not exist
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE MATERIALIZED VIEW IF NOT EXISTS schw_hierarchy AS
                                    ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS schw_hierarchy_uuid ON sch...
                               ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS schw_hierarchy_parent_uuid ON sch...
                        ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
ERROR:  relation "schw_hierarchy" does not exist
ERROR:  relation "useview_exit" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_exit_reported_pati...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_household_survey" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_household_survey_r...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_pregnancy" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_pregnancy_reported...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_trace_referral_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_trace_referral_fol...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  syntax error at or near "IS"
LINE 1: CREATE MATERIALIZED VIEW IS NOT EXISTS form_metadata AS
                                 ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS form_metadata_uuid on form...
                               ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS form_metadata_reported_by form_me...
                        ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS form_metadata_reported ON form_me...
                        ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS form_metadata_formname ON form_me...
                        ^
ERROR:  relation "useview_facility_reports" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_facility_reports_r...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_immunization" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_immunization_repor...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_referral_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_referral_follow_up...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_trace" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_trace_reported_tra...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  operator does not exist: jsonb ->> boolean
LINE 28: ...->>'type' = 'data_record' AND doc ? 'form' AND doc->>'form' ...
                                                              ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS formview_reported_reported...
                               ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS formview_reported_parent_uuid ON ...
                        ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
ERROR:  relation "formview_reported" does not exist
ERROR:  relation "useview_fp_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_fp_follow_up_repor...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_monthly_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_monthly_follow_up_...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_sputum_collection" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_sputum_collection_...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_treatment_enrolment" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_treatment_enrolmen...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_daily_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_daily_follow_up_re...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_fp_screening" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_fp_screening_repor...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_newborn_postnatal_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS newborn_pnc_follow_up_repo...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_tb_home_visit" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_tb_home_visit_repo...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_under_5_screening" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS under_5_screening_reported...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_death" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_death_reported_pat...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_hiv_home_visit" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_hiv_home_visit_rep...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_over_5_screening" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS over_5_screening_reported_...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_tb_results" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_tb_results_reporte...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_delivery" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_delivery_reported_...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_hiv_screening" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_hiv_screening_repo...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
DROP MATERIALIZED VIEW
SELECT 32343
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_population_demogra...
                               ^
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE INDEX IF NOT EXISTS useview_population_demographics_r...
                        ^
ERROR:  relation "useview_tb_results_task" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_tb_results_task_re...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_discharge_instructions" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_discharge_instruct...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_hiv_home_visit" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_hiv_home_visit_rep...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_postnatal_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS pnc_follow_up_reported_pat...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_tb_screening" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_tb_screening_repor...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_discharge" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_discharge_reported...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_hospitalization" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_hospitalization_re...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_pregnancy_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_pregnancy_follow_u...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT
ERROR:  relation "useview_trace_follow_up" already exists
ERROR:  syntax error at or near "NOT"
LINE 1: CREATE UNIQUE INDEX IF NOT EXISTS useview_trace_follow_up_re...
                               ^
ERROR:  syntax error at or near "current_user"
LINE 1: REASSIGN OWNED BY current_user TO full_access;
                          ^
GRANT