| From: | "imageguy" <imageguy1206(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using transactions with plpythonu |
| Date: | 2007-01-22 13:48:16 |
| Message-ID: | 1169473695.953876.84310@m58g2000cwm.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> "imageguy" <imageguy1206(at)gmail(dot)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.
>
Tom, I newbie and have only been using postgresql for about 2-3 weeks,
so I hope you will forgive my for jumping to an erroneous conclusion.
As stated in a previous post I will rework my test enviroment so I have
a better understanding functions and transactions.
Thanks again help.
Geoff.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Germán Hüttemann Arza | 2007-01-22 13:58:27 | Enable/Disable Triggers |
| Previous Message | Ron Johnson | 2007-01-22 13:46:10 | Re: Installing Postegres side-by-side with M$ SQL server |