Thread: Force Commit
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;
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
WHEN OTHERS THEN
COMMIT;
END ;
END ;
$BODY$;
END ;
END ;
$BODY$;
How can I do force commit ?
Thanks..
st 5. 2. 2020 v 9:10 odesílatel İlyas Derse <ilyasderse@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 THENCOMMIT;
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
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@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 THENCOMMIT;
END ;
END ;
$BODY$;How can I do force commit ?Thanks..