postgresql - Postgres set local begin/commit -


Document for local states set:

"Note that there will be no effect for SET LOCAL This is executed outside of a BEGIN block, because the transaction will end immediately. "

If I am using the SET local only in the context of reading, then I will end the transaction with commmat Will the sign statement be given? If it does or does not, then does it matter?

If your connection is COMMIT , PostgreSQL automatically returns a rollback will not release it in the context of read-only transactions.

If your transaction is open after your transaction, then you ROLLBACK (or


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -