Re: define transaction within pg/psql. Necessary?

From: Antonio Goméz Soto <antonio(dot)gomez(dot)soto(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: define transaction within pg/psql. Necessary?
Date: 2010-02-18 10:28:21
Message-ID: 4B7D1645.3050003@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Op 18-02-10 11:07, Richard Huxton schreef:
> On 18/02/10 10:02, Antonio Goméz Soto wrote:
>>
>> if I define a pg/pgsql function, and I call that outside a transaction,
>> does it create one for itself? Or should I add BEGIN and COMMIT
>> statements within
>> the function?
>
> You can't call a function outside a transaction. Every statement in
> PostgreSQL is inside a transaction, either one you define yourself, or
> an implicit one that just lasts for the duration of one statement.
>

Clear answer. Thanks.

Antonio

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2010-02-18 10:31:37 Re: Define permissions at database level
Previous Message dipti shah 2010-02-18 10:23:54 Re: Define permissions at database level