Horton

Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used

Alexander Law <exclusion@gmail.com>

View thread View on postgr.es
From: Alexander Lakhin <exclusion@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Paquier <michael@paquier.xyz>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, pgsql-bugs@lists.postgresql.org
Date: 2023-10-20T11:00:00Z
Lists: pgsql-bugs 
14.10.2023 23:20, Tom Lane wrote:
> I've fixed both sets of functions as of now.  We still need to look
> into the question of whether detoasting syscache entries is safe.

Unfortunately, the answer is "no". Please look at the proof:
https://www.postgresql.org/message-id/18163-859bad19a43edcf6%40postgresql.org

Best regards,
Alexander

Commits

  1. Harden xxx_is_visible() functions against concurrent object drops.

  2. Harden has_xxx_privilege() functions against concurrent object drops.