Using transactions with plpythonu

From: "imageguy" <imageguy1206(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Using transactions with plpythonu
Date: 2007-01-21 12:56:23
Message-ID: 1169384183.620450.301930@m58g2000cwm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Poe 2007-01-21 13:13:58 Replicating Binary Data from MS SQL 2000 to PG 8.2
Previous Message Simon Riggs 2007-01-21 12:24:38 Re: [HACKERS] Autovacuum Improvements