ERROR:  query string argument of EXECUTE is null
CONTEXT:  PL/pgSQL function inline_code_block line 11 at EXECUTE
SQL-состояние: 22004

DO $$
DECLARE
    tables CURSOR FOR
        select "MEMNAME" 
			    from public.lib_mem_tables 
			   where "LIBNAME"='CLC_BUY'
			     and "MEMNAME" like 'ISP_RES_BUY%'
				 order by "MEMNAME";
BEGIN
    FOR i IN tables LOOP
		execute 'insert into clc_buy.isp_res_buy
				 select comcode,
						y,
						m,
						f,
						date,
						mater_mat_id,
						mat_name,
						purchase,
						purchase_cost,
						'||substr(i."MEMNAME",11,31)||',
						'||null||'
				   from '||i."MEMNAME"||' t';
    END LOOP;
END$$;

ERROR:  relation "clc_buy.isp_res_buy" does not exist
LINE 1: insert into clc_buy.isp_res_buy

DO $$
DECLARE
    tables CURSOR FOR
        select "MEMNAME" 
			    from public.lib_mem_tables 
			   where "LIBNAME"='CLC_BUY'
			     and "MEMNAME" like 'ISP_RES_BUY%'
				 order by "MEMNAME";
BEGIN
    FOR i IN tables LOOP
		execute 'insert into clc_buy.isp_res_buy
				 select comcode,
						y,
						m,
						f,
						date,
						mater_mat_id,
						mat_name,
						purchase,
						purchase_cost,
						'||substr(i."MEMNAME",11,31)||',
						'||1||'
				   from '||i."MEMNAME"||' t';
    END LOOP;
END$$;