Re: Repeatable read transaction doesn't see dropped table

On Mon, Dec 23, 2024 at 3:17 PM David G. Johnston wrote: > The quoted section describes how two consecutive select queries will see the > same data. Your example shows how a single query behaves in isolation. The > “as the first query saw it” is fundamentally important since until it > succe

Re: Repeatable read transaction doesn't see dropped table

On 23/12/2024 10:17, David G. Johnston wrote: On Monday, December 23, 2024, Daniil Davydov <3daniss...@gmail.com > wrote: Hi, The documentation for PostgreSQL 17 says the following : "query in a repeatable read transaction sees a snapshot as of the s

Re: Repeatable read transaction doesn't see dropped table

On Monday, December 23, 2024, Daniil Davydov <3daniss...@gmail.com> wrote: > Hi, > The documentation for PostgreSQL 17 says the following : > "query in a repeatable read transaction sees a snapshot as of the > start of the first non-transaction-control statement in the > transaction, not as of the

Repeatable read transaction doesn't see dropped table

Hi, The documentation for PostgreSQL 17 says the following : "query in a repeatable read transaction sees a snapshot as of the start of the first non-transaction-control statement in the transaction, not as of the start of the current statement within the transaction" But I noticed this behavior (