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 wrote:
>
> I'm writing to you about Commit. I want to do force commit query even if I
> have
st 5. 2. 2020 v 9:10 odesílatel İlyas Derse 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 $B
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
