st 5. 2. 2020 v 9:10 odesílatel İlyas Derse <ilyasde...@gmail.com> napsal:
> 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.. > just you cannot to do it. There is not possibility how to do it now. Regards Pavel
