Re: Using transactions with plpythonu - Mailing list pgsql-general

From Tom Lane
Subject Re: Using transactions with plpythonu
Date
Msg-id 27799.1169403126@sss.pgh.pa.us
Whole thread Raw
In response to Using transactions with plpythonu  ("imageguy" <imageguy1206@gmail.com>)
Responses Re: Using transactions with plpythonu  ("imageguy" <imageguy1206@gmail.com>)
List pgsql-general
"imageguy" <imageguy1206@gmail.com> writes:
> In my testing so far, it seems that each call to plpy.execute('INSERT
> INTO ....') is committed immediately.

On what do you base that (erroneous) conclusion?

The fact that a transaction can see its own updates does not mean they
are committed.

            regards, tom lane

pgsql-general by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: Migrate 8.0 dump to 7.4
Next
From: Tom Lane
Date:
Subject: Re: Using transactions with plpythonu