diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2013-02-17 23:45:36 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2013-02-17 23:45:36 -0500 |
| commit | 9475db3a4eb5876b364254886d2730db01e042fd (patch) | |
| tree | 63b7678c3c36831361ef202245b65a412b20c08f /src/backend/parser | |
| parent | 17f15239325a88581bb4f9cf91d38005f1f52d69 (diff) | |
| download | postgresql-9475db3a4eb5876b364254886d2730db01e042fd.tar.gz postgresql-9475db3a4eb5876b364254886d2730db01e042fd.zip | |
Add ALTER ROLE ALL SET command
This generalizes the existing ALTER ROLE ... SET and ALTER DATABASE
... SET functionality to allow creating settings that apply to all users
in all databases.
reviewed by Pavel Stehule
Diffstat (limited to 'src/backend/parser')
| -rw-r--r-- | src/backend/parser/gram.y | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index fee05311c5c..b998431f5f3 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -1020,6 +1020,14 @@ AlterRoleSetStmt: n->setstmt = $5; $$ = (Node *)n; } + | ALTER ROLE ALL opt_in_database SetResetClause + { + AlterRoleSetStmt *n = makeNode(AlterRoleSetStmt); + n->role = NULL; + n->database = $4; + n->setstmt = $5; + $$ = (Node *)n; + } ; |