postgres.git / summary / log / commit / refs

commit    33bfad0f3cad222e4a2593cc774234e3117f1bc0
Author:   Peter Eisentraut <peter@eisentraut.org>
Date:     Mon Jul 06 09:44:55 2026 +0000

    Remove apparent support for SECURITY LABEL ON PROPERTY GRAPH
    
    Commit 2f094e7ac69 added a mention of SECURITY LABEL ON PROPERTY GRAPH
    to the SECURITY LABEL reference page, and it added support to psql tab
    completion.  However, security labels on property graphs are not
    actually supported (per SecLabelSupportsObjectType()).  The syntax
    does work, but that is just a result of how gram.y is factored.  We
    don't document or tab-complete the syntax of SECURITY LABEL for other
    object types that are not actually supported, so it was inconsistent
    to do this for property graphs.  Thus, remove this.
    
    Reported-by: Noah Misch <noah@leadboat.com>
    Discussion: https://www.postgresql.org/message-id/flat/20260704221210.08.noahmisch%40microsoft.com


doc/src/sgml/ref/security_label.sgml | 1 - src/bin/psql/tab-complete.in.c | 4 +--- 2 files changed, 1 insertion(+), 4 deletions(-) diff --git a/doc/src/sgml/ref/security_label.sgml b/doc/src/sgml/ref/security_label.sgml index c112f7a08a7..aa45c0af248 100644 --- a/doc/src/sgml/ref/security_label.sgml +++ b/doc/src/sgml/ref/security_label.sgml @@ -35,7 +35,6 @@ SECURITY LABEL [ FOR <replaceable class="parameter">provider</replaceable> ] ON MATERIALIZED VIEW <replaceable class="parameter">object_name</replaceable> | [ PROCEDURAL ] LANGUAGE <replaceable class="parameter">object_name</replaceable> | PROCEDURE <replaceable class="parameter">procedure_name</replaceable> [ ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] ) ] | - PROPERTY GRAPH <replaceable class="parameter">object_name</replaceable> PUBLICATION <replaceable class="parameter">object_name</replaceable> | ROLE <replaceable class="parameter">object_name</replaceable> | ROUTINE <replaceable class="parameter">routine_name</replaceable> [ ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] ) ] | diff --git a/src/bin/psql/tab-complete.in.c b/src/bin/psql/tab-complete.in.c index b783f123643..6207c91d482 100644 --- a/src/bin/psql/tab-complete.in.c +++ b/src/bin/psql/tab-complete.in.c @@ -5270,10 +5270,8 @@ match_previous_words(int pattern_id, COMPLETE_WITH("TABLE", "COLUMN", "AGGREGATE", "DATABASE", "DOMAIN", "EVENT TRIGGER", "FOREIGN TABLE", "FUNCTION", "LARGE OBJECT", "MATERIALIZED VIEW", "LANGUAGE", - "PROPERTY GRAPH", "PUBLICATION", "PROCEDURE", "ROLE", "ROUTINE", "SCHEMA", + "PUBLICATION", "PROCEDURE", "ROLE", "ROUTINE", "SCHEMA", "SEQUENCE", "SUBSCRIPTION", "TABLESPACE", "TYPE", "VIEW"); - else if (Matches("SECURITY", "LABEL", "ON", "PROPERTY", "GRAPH")) - COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_propgraphs); else if (Matches("SECURITY", "LABEL", "ON", MatchAny, MatchAny)) COMPLETE_WITH("IS"); [parent: c8d49ffb007b]