select pgn.nspname::text as col_schema, pgcl.relname::text as col_table,pga.attname::text as FK_table, pgcon.conkey::bigint[] as col_pk_nums,price.price_id::text as price_id,
    ARRAY(
      select pga2.attname
      from pg_attribute as pga2
      where (pga2.attrelid = pgcl.oid)
      and (pga2.attname like '%price%')
      order by pga2.attnum
    )::text[] as col_all_columns
    --select *
    from pg_class as pgcl, pg_namespace as pgn, pg_attribute as pga, pg_constraint as pgcon,common.price
    where (pgcl.relkind = 'r')
    and (pgcl.relnamespace = pgn.oid)
    and (pgn.nspname = 'common')
    and (pga.attrelid = pgcl.oid)
    and (pga.attndims = 0)
    and (pga.attname like '%price%')
    and (pgcon.contype = 'p')
    and (pgcon.conrelid = pgcl.oid)
    and (pgcl.relname != 'price')
    order by pgcl.relname

CREATE OR REPLACE FUNCTION localization.test(in_mode text)
  RETURNS integer AS
$BODY$
declare
  i_res bigint;
  i bigint;
  
  rec1 record;
  rec2 record;
  curs1 refcursor;
  
  sql_array text[];
  pk_array text[];
  pk_str text;
  the_sql text;
  a_cprop text;

  i_res2 bigint;
  needed_i_res2 bigint;
begin
  if(in_mode = 'they') then
    needed_i_res2 := 1;
  else
    needed_i_res2 := 0;
  end if;

  for rec1 in
    select pgn.nspname::text as col_schema, pgcl.relname::text as col_table, pga.attname::text as col_cprops, pgcon.conkey::bigint[] as col_pk_nums,
    ARRAY(
      select pga2.attname
      from pg_attribute as pga2
      where (pga2.attrelid = pgcl.oid)
      and (pga2.attname like '%price%')
      order by pga2.attnum
    )::text[] as col_all_columns
    --select *
    from pg_class as pgcl, pg_namespace as pgn, pg_attribute as pga, pg_constraint as pgcon
    where (pgcl.relkind = 'r')
    and (pgcl.relnamespace = pgn.oid)
    and (pgn.nspname = 'common')
    and (pga.attrelid = pgcl.oid)
    and (pga.attndims = 0)
    and (pga.attname like '%price%')
    and (pgcon.contype = 'p')
    and (pgcon.conrelid = pgcl.oid)
    and (pgcl.relname != 'price')
    order by pgcl.relname
  loop
    --raise notice '111 %', rec1.col_table;
    
    -- client_props2
    if(rec1.col_table = 'building_level') or (rec1.col_table = 'buy_pos') 
    or (rec1.col_table = 'condition')or (rec1.col_table = 'defence_type_prices')
    or (rec1.col_table = 'factory_pos')or (rec1.col_table = 'location')
    or (rec1.col_table = 'location_sector')or (rec1.col_table = 'price_item')
    or (rec1.col_table = 'price_unit')or (rec1.col_table = 'client_props2')
    or (rec1.col_table = 'reward')or (rec1.col_table = 'tech_level') then
      continue;
    end if;

    sql_array := ARRAY[]::text[];
	pk_array := ARRAY[]::text[];
    pk_str := '';
    
    for i in 1..coalesce(array_upper(rec1.col_pk_nums, 1), 0) loop
      pk_array := array_append(pk_array, rec1.col_all_columns[rec1.col_pk_nums[i]]);
    end loop;
    pk_str := array_to_string(pk_array, ', ');
    --raise notice '222 %', pk_str;
    
    sql_array := array_append(sql_array, 'select ARRAY[' || pk_str || ']::text[] as col_pk_vals, ' || rec1.col_cprops || '::text[] as col_cprops_vals');
    sql_array := array_append(sql_array, 'from ' || (rec1.col_schema || '.' || rec1.col_table));
    sql_array := array_append(sql_array, 'order by ' || pk_str);
    sql_array := array_append(sql_array, ';');
    the_sql := array_to_string(sql_array, ' ');
    --raise notice '333 %', the_sql;
    
    open curs1 for execute the_sql;
    while true loop
      fetch curs1 into rec2;
      if (rec2 is null) then
        --raise notice '555 exiting';
        exit;
      end if;
      --raise notice '444 % %', rec2.col_pk_vals, rec2.col_cprops_vals;
      
      for i in 1..coalesce(array_upper(rec2.col_cprops_vals, 1), 0) loop
        a_cprop := rec2.col_cprops_vals[i];

        i_res2 := localization.get_is_for_them(rec1.col_table, rec1.col_cprops, i);
        if(i_res2 = needed_i_res2) then
          if(a_cprop ~* '[абвгдеёжзийклмнопрстуфхцчшщъыьэюя]') then
            raise notice '_("%"); //%.%.%[%] . PK: %', a_cprop, rec1.col_schema, rec1.col_table, rec1.col_cprops, i::text, rec2.col_pk_vals::text;
          end if;
        end if;
      end loop;
    end loop;
    
    close curs1;
  end loop;
  

  
  return 0;
end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION localization.test(text)
  OWNER TO el5;

raise notice '_("%"); //%.%.%[%] . PK: %', a_cprop, rec1.col_schema, rec1.col_table, rec1.col_cprops, i::text, rec2.col_pk_vals::text;