pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #18824: Inconsistent results for isolation level settings 2+ messages / 2 participants [nested] [flat]
* BUG #18824: Inconsistent results for isolation level settings @ 2025-02-25 04:15 PG Bug reporting form <noreply@postgresql.org> 2025-02-25 13:26 ` Re: BUG #18824: Inconsistent results for isolation level settings Greg Sabino Mullane <htamfids@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2025-02-25 04:15 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: 2322370369@qq.com The following bug has been logged on the website: Bug reference: 18824 Logged by: dlyixue Email address: 2322370369@qq.com PostgreSQL version: 17.3 Operating system: Ubuntu 22.04 Description: When I was trying to set the isolation level, I realized that different methods of setting the same isolation level gave inconsistent results. This makes me wonder if the current setting is taking effect. In my opinion, use case 1 and use case 2 should have the same results. Why are the results of the queries different? Is this a design problem? I feel like the documentation needs to explain the difference as well. The test cases are as follows: Case 1: reproduce=# BEGIN; BEGIN reproduce=*# SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE; SET reproduce=*# SHOW TRANSACTION ISOLATION LEVEL; transaction_isolation ----------------------- read committed (1 row) Case 2: reproduce=# BEGIN; BEGIN reproduce=*# SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; SET reproduce=*# SHOW TRANSACTION ISOLATION LEVEL; transaction_isolation ----------------------- serializable (1 row) ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18824: Inconsistent results for isolation level settings 2025-02-25 04:15 BUG #18824: Inconsistent results for isolation level settings PG Bug reporting form <noreply@postgresql.org> @ 2025-02-25 13:26 ` Greg Sabino Mullane <htamfids@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Greg Sabino Mullane @ 2025-02-25 13:26 UTC (permalink / raw) To: 2322370369@qq.com; pgsql-bugs@lists.postgresql.org ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-02-25 13:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-02-25 04:15 BUG #18824: Inconsistent results for isolation level settings PG Bug reporting form <noreply@postgresql.org> 2025-02-25 13:26 ` Greg Sabino Mullane <htamfids@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox