Re: Using transactions with plpythonu

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Using transactions with plpythonu
Дата
Msg-id 20070121134524.GC2123@svana.org
обсуждение исходный текст
Ответ на Using transactions with plpythonu  ("imageguy" <imageguy1206@gmail.com>)
Ответы Re: Using transactions with plpythonu  ("imageguy" <imageguy1206@gmail.com>)
Re: Using transactions with plpythonu  ("imageguy" <imageguy1206@gmail.com>)
Список pgsql-general
On Sun, Jan 21, 2007 at 04:56:23AM -0800, imageguy wrote:
> Does anyone have an example of using transactions with plpythonu ?
>
> In my testing so far, it seems that each call to plpy.execute('INSERT
> INTO ....') is committed immediately.

What happens if you do:

plpy.execute("BEGIN");

before and after

plpy.execute("COMMIT");

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [HACKERS] Autovacuum Improvements
Следующее
От: "Chad Wagner"
Дата:
Сообщение: Re: More grist for the PostgreSQL vs MySQL mill