Re: Reject access to unlogged tables in contrib modules

Hi Kirill

On 25/10/2026 07:11, Kirill Reshke wrote:
> Then on standby:
>
> reshke=# table u_toast;
> ERROR: cannot access temporary or unlogged relations during recovery
> reshke=# SELECT octet_length(t_attrs[1])
> FROM u_snapshot,
> LATERAL heap_page_item_attrs(raw, 'u_toast'::regclass, true);
> ERROR: could not open file "base/16384/16393": No such file or directory
> CONTEXT: SQL function "heap_page_item_attrs" statement 1

Nice catch! I could reproduce the error and can confirm that your patch
fixes it -- now merged into 0001. The remaining patches 0002 - 0004
remain unchanged.
>
> attached fixes an issue.
> Also, Im +0.5 on not creating a TAP test for that -- too many cpu
> cycles for too little benefit.

Yeah, this is was my rationale as well.

v2 attached.

Thanks!

Best, Jim