tests: Expand temp table tests to some pin related matters

Andres Freund <andres@anarazel.de>

Commit: 1a22a8a0f1319e3d80cab0962374f235359b59ff
Author: Andres Freund <andres@anarazel.de>
Date: 2025-03-17T18:12:44Z
Releases: 18.0
tests: Expand temp table tests to some pin related matters

Added tests:
- recovery from running out of unpinned local buffers
- that we don't run out of unpinned buffers due to read stream (only recently
  fixed, in 92fc6856cb4)
- temp tables can't be dropped while in use by cursors

Discussion: weskknhckugbdm2yt7sa2uq53xlsax67gcdkac34sanb7qpd3p@hcc2wadao5wy
Discussion: https://postgr.es/m/ge6nsuddurhpmll3xj22vucvqwp4agqz6ndtcf2mhyeydzarst@l75dman5x53p

Files

PathChange+/−
src/test/regress/expected/temp.out modified +156 −0
src/test/regress/parallel_schedule modified +1 −1
src/test/regress/sql/temp.sql modified +107 −0

Discussion

  • AIO v2.0 213 messages · 2024-09-01 → 2025-07-29