Re: Is replacing transactions with CTE a good idea?

On Sun, 4 Apr 2021 at 09:12, Bruce Momjian wrote: > On Sun, Apr 4, 2021 at 08:35:41AM -0400, Dave Cramer wrote: > > > > > > On Thu, 1 Apr 2021 at 15:39, Bruce Momjian wrote: > > > > On Thu, Apr 1, 2021 at 11:24:48AM -0400, Dave Cramer wrote: > > > CTE's don't change the isolation level

Re: Is replacing transactions with CTE a good idea?

On Sun, Apr 4, 2021 at 08:35:41AM -0400, Dave Cramer wrote: > > > On Thu, 1 Apr 2021 at 15:39, Bruce Momjian wrote: > > On Thu, Apr  1, 2021 at 11:24:48AM -0400, Dave Cramer wrote: > > CTE's don't change the isolation level. I'm not sure what you are > getting > at > > here ?

Re: Is replacing transactions with CTE a good idea?

On Thu, 1 Apr 2021 at 15:39, Bruce Momjian wrote: > On Thu, Apr 1, 2021 at 11:24:48AM -0400, Dave Cramer wrote: > > CTE's don't change the isolation level. I'm not sure what you are > getting at > > here ? > > I think what he/she means here is that all queries in a CTE use a single > snapshot, m