Also AFAICT the schema created for the temp table does not get deleted
at the end of the session which also causes issues.
On Fri, Jul 7, 2023 at 7:43 AM Ted Toth <txtoth(at)gmail(dot)com> wrote:
>
> I'm seeing security labels set on db objects when a temporary table is
> created but they don't match the labels I've configured in my
> sepgsql_contexts file. Our code doesn't actually execute a "SECURITY
> LABEL ..." command for the temp tables but something else must be
> doing so because I see pg_temp_NNN in pg_seclabels. So I'm confused at
> how the objects are being labeled, can anyone help me understand how
> this is happening?
>
> Ted