Re: No warning/error trying to vacuum other session's temp table

2019-08-27 Thread Tom Lane
Jerry Sievers writes: > As seen below, the command response VACUUM is output , but adding the > VERBOSe keyword results in no additional output. Yeah, per the code: /* * Silently ignore tables that are temp tables of other backends --- * trying to vacuum these will lead to great un

No warning/error trying to vacuum other session's temp table

2019-08-27 Thread Jerry Sievers
Greetings! Spent a bit of head scratching time today responding to a case of old temp tables possibly threatening one of our reporting systems due to txid wrap. There is such an old enough backendID still live that I speculated one or more of these temp tables still possibly in use... which got m