Re: chained transactions - Mailing list pgsql-hackers

From Andres Freund
Subject Re: chained transactions
Date
Msg-id 20180305194913.g2olpd6tagmiv3qu@alap3.anarazel.de
Whole thread Raw
In response to Re: chained transactions  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On 2018-03-05 09:21:33 +0000, Simon Riggs wrote:
> On 2 March 2018 at 07:18, Andres Freund <andres@anarazel.de> wrote:
> > Hi,
> >
> > On 2018-02-28 22:35:52 -0500, Peter Eisentraut wrote:
> >> This feature is meant to help manage transaction isolation in
> >> procedures.
> >
> > This is a major new feature, submitted the evening before the last CF
> > for v11 starts. Therefore I think it should just be moved to the next
> > fest, it doesn't seems realistic to attempt to get this into v11.
> 
> Looks like a useful patch that adds fairly minor syntax that follows
> the SQL Standard.
> 
> It introduces no new internal infrastructure, so I can't call this a
> major feature.

You can avoid calling it new infrastructure, but it certainly modifies
new one. And it adds quite some new user interface, which certainly make
s it important to get it right.

 doc/src/sgml/plpgsql.sgml                           |    9 
 doc/src/sgml/ref/abort.sgml                         |   14 +
 doc/src/sgml/ref/commit.sgml                        |   14 +
 doc/src/sgml/ref/end.sgml                           |   14 +
 doc/src/sgml/ref/rollback.sgml                      |   14 +
 doc/src/sgml/spi.sgml                               |   14 -
 src/backend/access/transam/xact.c                   |  210 +++++++++++---------
 src/backend/commands/cluster.c                      |    2 
 src/backend/commands/dbcommands.c                   |    2 
 src/backend/commands/discard.c                      |    2 
 src/backend/commands/portalcmds.c                   |    2 
 src/backend/commands/subscriptioncmds.c             |    4 
 src/backend/commands/typecmds.c                     |    2 
 src/backend/commands/vacuum.c                       |    4 
 src/backend/commands/variable.c                     |   57 -----
 src/backend/executor/spi.c                          |   25 ++
 src/backend/nodes/copyfuncs.c                       |    2 
 src/backend/nodes/equalfuncs.c                      |    2 
 src/backend/parser/gram.y                           |   34 +--
 src/backend/replication/walsender.c                 |    6 
 src/backend/tcop/utility.c                          |   58 ++---
 src/backend/utils/misc/guc.c                        |   35 +--
 src/backend/utils/time/snapmgr.c                    |    2 
 src/bin/psql/common.c                               |    2 
 src/include/access/xact.h                           |   18 -
 src/include/commands/variable.h                     |    4 
 src/include/executor/spi.h                          |    4 
 src/include/nodes/parsenodes.h                      |    4 
 src/pl/plperl/plperl.c                              |    4 
 src/pl/plpgsql/src/expected/plpgsql_transaction.out |   31 ++
 src/pl/plpgsql/src/pl_exec.c                        |   10 
 src/pl/plpgsql/src/pl_funcs.c                       |   10 
 src/pl/plpgsql/src/pl_gram.y                        |   18 +
 src/pl/plpgsql/src/pl_scanner.c                     |    2 
 src/pl/plpgsql/src/plpgsql.h                        |    2 
 src/pl/plpgsql/src/sql/plpgsql_transaction.sql      |   23 ++
 src/pl/plpython/plpy_plpymodule.c                   |    4 
 src/pl/tcl/pltcl.c                                  |    4 
 src/test/regress/expected/transactions.out          |  141 +++++++++++++
 src/test/regress/sql/transactions.sql               |   49 ++++
 40 files changed, 596 insertions(+), 262 deletions(-)


Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] generated columns
Next
From: Thomas Munro
Date:
Subject: Re: select_parallel test failure: gather sometimes losing tuples(maybe during rescans)?