Re: Force Commit

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 <ilyasderse(at)gmail(dot)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..