Re: error when executing dynamic commands with transaction

Shridhar Daithankar wrote:

> 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.

Argh.. read that as 'can not call begin/commit in a function'.

  Shridhar