Hi Adrian, > On 26 Nov 2024, at 17:56, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > > Did you commit the statements?
Yes. I have autocommit on, the psql default. > Are you using concurrent sessions to do this? No. I do this in one session. 1. select, 2. drop, 3. add, 4. select. > When you run the query again do you get the same two statements? Yes. I can repeat the above 4 steps as much as I want. The result remains the same. I would have expected to have an empty result doing the final repeated select, but it shows exactly the same output. Cheers, Paul
