Re: Force Commit

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

st 5. 2. 2020 v 9:10 odesílatel İlyas Derse <ilyasderse@xxxxxxxxx> 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