Thank you !

Best Regards

2013/7/9 Adrian.Vondendriesch <[email protected]>

> Hello,
>
> Am 09.07.2013 11:29, schrieb 高健:
> > 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?
>
> Yes it is.
>
> If you have a look at the todo list at
> http://wiki.postgresql.org/wiki/Todo (Exotic Features) you will see,
> that it's marked as outstanding.
>
> >
> >
> >
> > Best Regards
> >
>
> Best Regards
>
>         - Adrian
>

Reply via email to