"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