The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/sql-set-transaction.html
Description:
Hello,
the wording on the SET TRANSACTION SNAPSHOT left me a bit confused. It says
"To begin a new transaction with the same snapshot as an already existing
transaction" and it feels like basically taking over an existing
session/transaction or being able to replicate a transaction from that
snapshot on. But I found that a temporary table created in Session 1 with
transaction A is not available from Session 2 with transaction B with
snapshot taken over from transaction A. I guess "obviously", as using the
snapshot does not give me the same permissions as the original transaction
starter so I can't replicate everything that Session 1 would have been able
to do in transaction A.
Also I couldn't find what the snapshot includes. Maybe it includes said
temporary table but the second session has no permissions to view it. Maybe
not. But I guess that's not actually important.
Maybe it is possible to add a sentence that starting from the snapshot of
another transaction does not include inheriting any permissions (or
temporary resources) on that snapshot. It's kinda obvious for different
users with different permission levels but especially the temporary table
case looks (at least with squinted eyes) like it could work.
All the best
Mario Wenzel