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..