Re: error when executing dynamic commands with transaction

From: Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net>
To: Pascal Polleunus <ppo(at)beeznest(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: error when executing dynamic commands with transaction
Date: 2004-02-12 10:46:20
Message-ID: 402B597C.1080601@frodo.hserus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pascal Polleunus 2004-02-12 10:49:21 Re: Is a capital letters title for this ML blocked?
Previous Message C G 2004-02-12 10:43:47 Re: pl/pythonu