PL/pgSQL: Add support for SET TRANSACTION
Peter Eisentraut <peter_e@gmx.net>
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.korotkov@postgrespro.ru> Reviewed-by: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Files
| Path | Change | +/− |
|---|---|---|
| src/pl/plpgsql/src/expected/plpgsql_transaction.out | modified | +29 −0 |
| src/pl/plpgsql/src/pl_exec.c | modified | +35 −0 |
| src/pl/plpgsql/src/pl_funcs.c | modified | +23 −0 |
| src/pl/plpgsql/src/pl_gram.y | modified | +31 −1 |
| src/pl/plpgsql/src/plpgsql.h | modified | +12 −1 |
| src/pl/plpgsql/src/pl_scanner.c | modified | +2 −0 |
| src/pl/plpgsql/src/sql/plpgsql_transaction.sql | modified | +25 −0 |