| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
| Cc: | Glen Huang <heyhgl(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Is replacing transactions with CTE a good idea? |
| Date: | 2021-04-05 18:41:31 |
| Message-ID: | 20210405184131.GB12174@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Apr 5, 2021 at 02:32:36PM -0400, Dave Cramer wrote:
> On Mon, 5 Apr 2021 at 14:18, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> I think we are in agreement. My point was that WITH queries don't change the
> isolation semantics.
My point is that when you combine individual queries in a single WITH
query, those queries run together with snaphot behavior as if they were
in a repeatable-read multi-statement transaction.
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryn Llewellyn | 2021-04-05 20:06:36 | Re: Have I found an interval arithmetic bug? |
| Previous Message | Bruce Momjian | 2021-04-05 18:37:54 | Re: Have I found an interval arithmetic bug? |