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