Skip site navigation (1) Skip section navigation (2)

pl/python SPI in subtransactions

From: Jan Urbański <wulczer(at)wulczer(dot)org>
To: Postgres - Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pl/python SPI in subtransactions
Date: 2010-12-23 13:45:28
Message-ID: 4D135278.8000409@wulczer.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Here's a patch implementing a executing SPI in an subtransaction
mentioned in
http://archives.postgresql.org/pgsql-hackers/2010-12/msg01991.php. It's
an incremental patch on top of the plpython-refactor patch sent eariler.

Git branch for this patch:
https://github.com/wulczer/postgres/tree/spi-in-subxacts.

Without it the error handling in PL/Python is really broken, as we jump
between from a saught longjmp back into Python without any cleanup. As
an additional bonus you no longer get all the ugly "unrecognized error
in PLy_spi_execute_query" errors.

Cheers,
Jan

Attachment: plpython-spi-in-subxacts.diff
Description: text/x-patch (9.7 KB)

Responses

pgsql-hackers by date

Next:From: Jan UrbańskiDate: 2010-12-23 13:50:46
Subject: pl/python invalidate functions with composite arguments
Previous:From: Jan UrbańskiDate: 2010-12-23 13:43:12
Subject: Re: pl/python validator function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group