Re: No toast table for pg_shseclabel but for pg_seclabel

On March 22, 2015 3:15:07 AM GMT+01:00, Bruce Momjian <bruce@momjian.us> wrote:
>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.

Thanks.

-- 
Please excuse brevity and formatting - I am writing this on my mobile phone.

Andres Freund                       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services