Using transactions with plpythonu

Поиск
Список
Период
Сортировка
От imageguy
Тема Using transactions with plpythonu
Дата
Msg-id 1169384183.620450.301930@m58g2000cwm.googlegroups.com
обсуждение исходный текст
Ответы Re: Using transactions with plpythonu  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Using transactions with plpythonu  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Does anyone have an example of using transactions with plpythonu ?

I want to create a function that receives data from a client app, and
then updates three different tables but I want to ensure they all get
updated before I commit.

In my testing so far, it seems that each call to plpy.execute('INSERT
INTO ....') is committed immediately.
Any hints or suggestions or is there a wiki page someone could point me
to ?

Thanks.


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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: [HACKERS] Autovacuum Improvements
Следующее
От: "Mike Poe"
Дата:
Сообщение: Replicating Binary Data from MS SQL 2000 to PG 8.2