Re: error when executing dynamic commands with transaction - Mailing list pgsql-general

Pascal Polleunus wrote:

> If I don't use a transaction in the executed statement, there is no
> problem.
> Remark: In this example a transaction is not needed, but in my real
> usage of this I'm creating a table and granting permissions, and maybe
> also creating a view. So a transaction is preferable.
>
> I've tested this on "PostgreSQL 7.4.1 on i386-pc-linux-gnu, compiled by
> GCC i386-linux-gcc (GCC) 3.3.2 (Debian)", Debian Sarge.

AFAIK, functions reside in transaction scope created by caller. So you can not
call begin/commit in a transaction.

Correct me if I am wrong..

  Shridhar