pgsql: Wrap PL/Python SPI calls into subtransactions

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Wrap PL/Python SPI calls into subtransactions
Date: 2011-02-02 20:09:12
Message-ID: E1Pkj0q-0006vw-Is@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Wrap PL/Python SPI calls into subtransactions

This allows the language-specific try/catch construct to catch and
handle exceptions arising from SPI calls, matching the behavior of
other PLs.

As an additional bonus you no longer get all the ugly "unrecognized
error in PLy_spi_execute_query" errors.

Jan Urbański, reviewed by Steve Singer

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0c5933d0104c1788479592a84cca53da357381f9

Modified Files
--------------
doc/src/sgml/plpython.sgml | 30 ++++++
src/pl/plpython/expected/plpython_error.out | 32 +++++--
src/pl/plpython/expected/plpython_error_0.out | 32 +++++--
src/pl/plpython/plpython.c | 118 ++++++++++++++++++++++---
src/pl/plpython/sql/plpython_error.sql | 22 +++++
5 files changed, 202 insertions(+), 32 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2011-02-02 20:40:55 pgsql: Simplify pg_upgrade checking of executable permissions.
Previous Message Andrew Dunstan 2011-02-02 17:48:55 pgsql: Add comment on why we're passing a useless 'false' to the plper