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

Explicit subtransactions for PL/Tcl

From: Victor Wagner <vitus(at)wagner(dot)pp(dot)ru>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Explicit subtransactions for PL/Tcl
Date: 2017-01-08 17:57:50
Message-ID: 20170108205750.2dab04a1@wagner.wagner.home (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
Collegues!

Recently I've found out that PL/Python have very nice feature - explicit
subtransaction object, which allows to execute block of code in the
context of subtransaction.

I've quite surprised that other PL languages, shipped with PostgreSQL do
not have such useful construction. 

If it might require considerable trickery to add such functionality into
PL/Perl, Tcl allows to add new control stuctures very easily.

I'm attaching the patch which implements subtransaction command for
PL/Tcl which does almost same as PL/Python plpy.subtransction context
manager object does: executes a block of Tcl code in the context of
subtransaction, rolls subtransaction back if error occures and commits
it otherwise.

It looks like

subtransaction {
     ...some Tcl code...
}

Typically one would use it inside Tcl catch statement:

if [catch {
	subtransaction {
		spi_exec "insert into..."
                ...
	}
} errormsg] {
   # Handle an error
}

See documentation and tests included in the patch for more complete
examples.

Just like corresponding Python construction, this command doesn't
replace language  builtin exception handling, just adds subtransaction 
support to it.

Patch includes sufficiently less tests than python subtransaction tests,
because Tcl implementation is way simpler than python one, and doesn't
have syntactic variatons which depend on language version.

Also entering and exiting subtransactions are in the same piece of code
rather than in separate __enter__ and __exit__ methods as in Python, so
there is no possibility to call exit without enter or vice versa.

-- 
                                   Victor Wagner <vitus(at)wagner(dot)pp(dot)ru>

Attachment: tcl_subtransaction_01.patch
Description: text/x-patch (0 bytes)

Responses

pgsql-hackers by date

Next:From: Victor WagnerDate: 2017-01-08 18:34:40
Subject: Re: Explicit subtransactions for PL/Tcl
Previous:From: Greg StarkDate: 2017-01-08 17:36:29
Subject: Re: [PATCH] guc-ify the formerly hard-coded MAX_SEND_SIZE to max_wal_send

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