Reindex concurrently - Mailing list pgsql-admin

From SOzcn
Subject Reindex concurrently
Date
Msg-id CAJyV5AanzhzubzCs0-Ergr3S_02FjHPWScNxnKB93L7mbRDTnw@mail.gmail.com
Whole thread Raw
Responses Re: Reindex concurrently
List pgsql-admin
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$

;

pgsql-admin by date:

Previous
From: SOzcn
Date:
Subject: Re: Log Rotation
Next
From: Holger Jakobs
Date:
Subject: Re: Reindex concurrently