Re: One question about security label command

Are you trying with sepgsql.so module?

From standpoint of SQL syntax, yep, SECURITY LABEL command support
the object types below, however, it fully depends on security label
provider; sepgsql.so in this case.
At this moment, it supports database, schema, function, tables and
column are supported by sepgsql. So, it is expected behavior.

Thanks,
--
NEC OSS Promotion Center / PG-Strom Project
KaiGai Kohei <kaigai@ak.jp.nec.com>


> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of ?元超
> Sent: Tuesday, March 03, 2015 6:33 PM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] One question about security label command
> 
> Greetings,
>     I got a problem when i used the 'security label on role ...' command to make
> a label for a database role.
> It show me an error like "ERROR:  unsupported object type: 1260".So i read the
> document about 'security label' command ,it show me like this:
> 
> SECURITY LABEL [ FOR provider ] ON
> {
>   TABLE object_name |
>   COLUMN table_name.column_name |
>   AGGREGATE aggregate_name ( aggregate_signature ) |
>   DATABASE object_name |
>   DOMAIN object_name |
>   EVENT TRIGGER object_name |
>   FOREIGN TABLE object_name
>   FUNCTION function_name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) |
>   LARGE OBJECT large_object_oid |
>   MATERIALIZED VIEW object_name |
>   [ PROCEDURAL ] LANGUAGE object_name |
>   ROLE object_name |
>   SCHEMA object_name |
>   SEQUENCE object_name |
>   TABLESPACE object_name |
>   TYPE object_name |
>   VIEW object_name
> } IS 'label'
> 
> where aggregate_signature is:
> 
> * |
> [ argmode ] [ argname ] argtype [ , ... ] |
> [ [ argmode ] [ argname ] argtype [ , ... ] ] ORDER BY [ argmode ] [ argname ]
> argtype [ , ... ]
> The document show that it can support the object_name named role,so i want to
> ask what lead to the problem.Thanks.
> 
> 
> 
> 
>