| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: PL/pgSQL: Add support for SET TRANSACTION |
| Date: | 2018-04-05 19:30:37 |
| Message-ID: | E1f4Aaj-0004vc-5g@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
PL/pgSQL: Add support for SET TRANSACTION
A normal SQL command run inside PL/pgSQL acquires a snapshot, but SET
TRANSACTION does not work anymore if a snapshot is set. So we have to
handle this separately.
Reviewed-by: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Reviewed-by: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/b981275b6531df5a4c4f069571bcb39fc4dee770
Modified Files
--------------
.../plpgsql/src/expected/plpgsql_transaction.out | 29 ++++++++++++++++++
src/pl/plpgsql/src/pl_exec.c | 35 ++++++++++++++++++++++
src/pl/plpgsql/src/pl_funcs.c | 23 ++++++++++++++
src/pl/plpgsql/src/pl_gram.y | 32 +++++++++++++++++++-
src/pl/plpgsql/src/pl_scanner.c | 2 ++
src/pl/plpgsql/src/plpgsql.h | 13 +++++++-
src/pl/plpgsql/src/sql/plpgsql_transaction.sql | 25 ++++++++++++++++
7 files changed, 157 insertions(+), 2 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2018-04-05 19:38:35 | pgsql: MERGE syntax diagram correction |
| Previous Message | Simon Riggs | 2018-04-05 19:10:25 | pgsql: Allow cpluspluscheck to pass by renaming variable |