temp table security labels

From: Ted Toth <txtoth(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: temp table security labels
Date: 2023-07-07 12:43:31
Message-ID: CAFPpqQE038svUYfNu54WUBMKg-ROirCHS290Evr+ifUxGDHOBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ted Toth 2023-07-07 13:05:05 Re: temp table security labels
Previous Message Lorusso Domenico 2023-07-07 11:03:41 Re: [bug]? insert returning composite type fails