do $$
declare
    rec caas_cluster%rowtype;
    l_mgmt_subnet character varying;
    l_mgmt_default_gateway character varying;
begin
    for rec in
        select id,
            cluster_name,
            oam_vip_hostname,
            oam_vip_address,
            mgmt_address_range_start,
            mgmt_address_range_end,
            csr_id,
            location_id,
            namespace_id,
            parent_cluster_id,
            sap_clli_id,
            vlan_id,
            is_central_controller,
            mgmt_default_gateway,
            mgmt_subnet
        from caas_cluster
        where is_central_controller = 0
    loop
        select mgmt_subnet into l_mgmt_subnet
        from caas_cellsiterouter
        where id = rec.csr_id;

        select mgmt_default_gateway into l_mgmt_default_gateway
        from caas_cellsiterouter
        where id = rec.csr_id;

        update caas_cluster
        set mgmt_subnet = l_mgmt_subnet,
            mgmt_default_gateway = l_mgmt_default_gateway
        where id = rec.id;
    end loop;
end;
$$ language plpgsql;