Re: Reindex concurrently

Hello team, 

We've been building a index maintenance scripts but in the function it doesn't work with concurrently, is there a way for manipulate that ? Just for example ; The reindexes are working without function. Have a nice day!

select index_stat.test ();

CREATE OR REPLACE FUNCTION index_stat.test()

RETURNS void

LANGUAGE plpgsql

AS $function$

begin

REINDEX INDEX CONCURRENTLY "players_id_idx";

commit;

REINDEX INDEX CONCURRENTLY "players_about_idx";

commit;

end;

$function$

;

Hello,

"doesn't work with" isn't a good description. Please always include the error message given.

What I would suggest instead is try using a procedure instead of a function.

Cheers

Holger

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012