My question about autonomous transaction

From: 高健 <luckyjackgao(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: My question about autonomous transaction
Date: 2013-07-09 09:29:21
Message-ID: CAL454F0_N0oj0NPVRxMQkLJ9V+tryRzefaQyOSnDWnbvsC-Cpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2013-07-09 10:20:46 Re: PERFORM statement
Previous Message itishree sukla 2013-07-09 09:26:09 Support for Foreign keys with arrays