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

From imageguy
Subject Re: Using transactions with plpythonu
Date
Msg-id 1169390885.070947.228130@q2g2000cwa.googlegroups.com
Whole thread Raw
In response to Re: Using transactions with plpythonu  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout wrote:
> On Sun, Jan 21, 2007 at 04:56:23AM -0800, imageguy wrote:
> > Does anyone have an example of using transactions with plpythonu ?
> >
> > In my testing so far, it seems that each call to plpy.execute('INSERT
> > INTO ....') is committed immediately.
>
> What happens if you do:
>
> plpy.execute("BEGIN");
>
> before and after
>
> plpy.execute("COMMIT");
>
> Have a nice day,
> --
> Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> > From each according to his ability. To each according to his ability to litigate.
>
> --4ZLFUWh1odzi/v6L
> Content-Type: application/pgp-signature
> Content-Disposition: inline;
>     filename="signature.asc"
> Content-Description: Digital signature
> X-Google-AttachSize: 190


pgsql-general by date:

Previous
From: "Chad Wagner"
Date:
Subject: Re: More grist for the PostgreSQL vs MySQL mill
Next
From: "imageguy"
Date:
Subject: Re: Using transactions with plpythonu