Re: No toast table for pg_shseclabel but for pg_seclabel - Mailing list pgsql-hackers

On Thu, Mar 19, 2015 at 11:50:36AM -0400, Bruce Momjian wrote:
> > Then there's the other discussion about using the security labels
> > structure for more than just security labels, which could end up with a
> > lot of other use-cases where the "label" is even larger.
> 
> OK, the attached patch adds a TOAST table to the shared table
> pg_shseclabel for use with long labels.  The new query output shows the
> shared and non-shared seclabel tables now both have TOAST tables:
> 
>     test=> SELECT oid::regclass, reltoastrelid FROM pg_class WHERE relname IN ('pg_seclabel', 'pg_shseclabel');
>           oid      | reltoastrelid
>     ---------------+---------------
>      pg_seclabel   |          3598
>      pg_shseclabel |          4060
>     (2 rows)
> 
> Previously pg_shseclabel was zero.

Patch applied.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +