You can workaround by simulation autonomous transaction using plpython or dblink. Or just performing a commit outside the stored procedure.
> On 5. Feb 2020, at 09:06, İlyas Derse <ilyasde...@gmail.com> wrote: > > I'm writing to you about Commit. I want to do force commit query even if I > have exception. > It's like : > > CREATE OR REPLACE PROCEDURE public."test"() > LANGUAGE 'plpgsql' > AS $BODY$ > DECLARE "a" integer ; > DECLARE "b" integer ; > BEGIN > "a" = 1; > "b" = 0; > BEGIN > raise notice 'hata'; > update public."crud" set lastname = 'Tekindor' where autoid = 20; > "a"="a"/"b"; > ROLLBACK; > > EXCEPTION > WHEN OTHERS THEN > > COMMIT; > END ; > END ; > $BODY$; > > How can I do force commit ? > Thanks..
