Re: Using transactions with plpythonu

From: "imageguy" <imageguy1206(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Using transactions with plpythonu
Date: 2007-01-21 14:48:05
Message-ID: 1169390885.070947.228130@q2g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message imageguy 2007-01-21 14:53:15 Re: Using transactions with plpythonu
Previous Message Chad Wagner 2007-01-21 13:55:33 Re: More grist for the PostgreSQL vs MySQL mill