From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | İlyas Derse <ilyasderse(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Force Commit |
Date: | 2020-02-05 08:11:39 |
Message-ID: | CAFj8pRCw-_7tXmht992X-jgf83bbk_de3OhwpWKhVxQPPjt8Dw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
st 5. 2. 2020 v 9:10 odesílatel İlyas Derse <ilyasderse(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Sonam Sharma | 2020-02-05 08:24:56 | Restore is failing |
Previous Message | İlyas Derse | 2020-02-05 08:06:00 | Force Commit |