OpenACS

michaela
committed
MAIN:michaela:20181217091347
on 17 Dec 18
[PostgreSQL 11] Change 'with (iscachable)' to IMMUTABLE for PG11
openacs-4/.../postgresql/postgresql.sql (+1 -1)
901 901
902 902  if (tgtype & 8) > 0 then
903 903     description := description || sep || 'DELETE ';
904 904     sep := 'OR ';
905 905  end if;
906 906
907 907  if (tgtype & 16) > 0 then
908 908     description := description || sep || 'UPDATE ';
909 909     sep := 'OR ';
910 910  end if;
911 911
912 912  if (tgtype & 1) > 0 then
913 913     description := description || 'FOR EACH ROW';
914 914  else
915 915     description := description || 'STATEMENT';
916 916  end if;
917 917
918 918  return description;
919 919
920 920 END;
921   $$ LANGUAGE plpgsql with (iscachable);
  921 $$ LANGUAGE plpgsql IMMUTABLE;
922 922
923 923
924 924 -- added
925 925 select define_function_args('instr','str,pat,dir,cnt');
926 926 select define_function_args('split','string,split_char,element');
927 927 select define_function_args('get_func_drop_command','fname');
928 928 select define_function_args('drop_package','package_name');
929 929 select define_function_args('number_src','v_src');
930 930 select define_function_args('get_func_definition','fname,args');
931 931 select define_function_args('get_func_header','fname,args');
932 932 select define_function_args('int_to_tree_key','intkey');
933 933 select define_function_args('tree_key_to_int','tree_key,level');
934 934 select define_function_args('tree_ancestor_key','tree_key,level');
935 935 select define_function_args('tree_root_key','tree_key');
936 936 select define_function_args('tree_leaf_key_to_int','tree_key');
937 937 select define_function_args('tree_next_key','parent_key,child_value');
938 938 select define_function_args('tree_increment_key','child_sort_key');
939 939 select define_function_args('tree_left','key');
940 940 select define_function_args('tree_right','key');
941 941 select define_function_args('tree_level','tree_key');