Re: define transaction within pg/psql. Necessary?

Поиск
Список
Период
Сортировка
От Antonio Goméz Soto
Тема Re: define transaction within pg/psql. Necessary?
Дата
Msg-id 4B7D1645.3050003@gmail.com
обсуждение исходный текст
Ответ на Re: define transaction within pg/psql. Necessary?  (Richard Huxton <dev@archonet.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: dipti shah
Дата:
Сообщение: Re: Define permissions at database level
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Define permissions at database level