Zmiany pomiędzy wersją 10 and wersją 11 dla AdminGuide/PSQLOWNER

Pokaż
Ignoruj:
Data i czas:
06/15/21 10:43:37 (3 years temu)
Autor:
wkruk (IP: 185.56.175.28)
Komentarz:

--

Legend:

Bez zmian
Dodane
Usunięte
Zmienione

  • AdminGuide/PSQLOWNER

    v10 v11  
    4747 
    4848{{{ 
    49 SELECT my_exec1( 'ALTER FUNCTION '||nsp.nspname||'.'||p.proname||'('||pg_get_function_identity_arguments(p.oid)||') OWNER TO edokumenty;') 
    50 from pg_proc p 
    51          join pg_namespace nsp ON p.pronamespace = nsp.oid 
    52 where nsp.nspname IN  ('public', 'epuap', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
     49SELECT my_exec1( 'ALTER FUNCTION '||nsp.nspname||'.'||p.proname||'('||pg_get_function_identity_arguments(p.oid)||') OWNER TO edokumenty;') from pg_proc p join pg_namespace nsp ON p.pronamespace = nsp.oid where nsp.nspname IN  ('public', 'epuap', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
    5350SELECT my_exec1( 'GRANT EXECUTE ON FUNCTION '||nsp.nspname||'.'||p.proname||'('||pg_get_function_identity_arguments(p.oid)||') TO http;') 
    54 from pg_proc p 
    55          join pg_namespace nsp ON p.pronamespace = nsp.oid 
    56 where nsp.nspname IN  ('public', 'epuap', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
     51from pg_proc p join pg_namespace nsp ON p.pronamespace = nsp.oid where nsp.nspname IN  ('public', 'epuap', 'syncml_server', 'reports', 'vindication', 'cregisters', 'custom', 'jet_search', 'sekap', 'translatica'); 
    5752}}} 
    5853