My question about autonomous transaction - Mailing list pgsql-general

From 高健
Subject My question about autonomous transaction
Date
Msg-id CAL454F0_N0oj0NPVRxMQkLJ9V+tryRzefaQyOSnDWnbvsC-Cpg@mail.gmail.com
Whole thread Raw
Responses Re: My question about autonomous transaction
List pgsql-general

Hello:

 

I have found the following wiki about autonomous transaction:

https://wiki.postgresql.org/wiki/Autonomous_subtransactions

 

But when I test it, I found the following error:

 

pgsql=# BEGIN;

BEGIN

pgsql=# INSERT INTO tab01 VALUES (1);

INSERT 0 1

pgsql=# BEGIN SUBTRANSACTION;

ERROR:  syntax error at or near "SUBTRANSACTION"

LINE 1: BEGIN SUBTRANSACTION;

              ^

pgsql=# 

 

So that sub transaction is still not supported in PostgreSQL,

Is my understanding right?

 

Best Regards

pgsql-general by date:

Previous
From: itishree sukla
Date:
Subject: Support for Foreign keys with arrays
Next
From: Raymond O'Donnell
Date:
Subject: Re: PERFORM statement