Hi Adrian,
> On 26 Nov 2024, at 17:56, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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