Using transactions with plpythonu - Mailing list pgsql-general

From imageguy
Subject Using transactions with plpythonu
Date
Msg-id 1169384183.620450.301930@m58g2000cwm.googlegroups.com
Whole thread Raw
Responses Re: Using transactions with plpythonu  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Using transactions with plpythonu  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: [HACKERS] Autovacuum Improvements
Next
From: "Mike Poe"
Date:
Subject: Replicating Binary Data from MS SQL 2000 to PG 8.2