Re: IF NOT EXISTS option for CREATE SERVER and CREATE USER MAPPING statements

On 15.02.2017 20:54, Anastasia Lubennikova wrote:
>
> Done.
>

I have gotten the error that AlterUserMappingStmt doesn't have 
if_not_exists (in Russian):

> gram.y: В функции «base_yyparse»:
> gram.y:4918:7: ошибка: «AlterUserMappingStmt {aka struct AlterUserMappingStmt}» не содержит элемента с именем «if_not_exists»
>       n->if_not_exists = false;
>        ^~

After applying the CREATE USER patch in gram.y I have:

>
> AlterUserMappingStmt: ALTER USER MAPPING FOR auth_ident SERVER name alter_generic_options
>                 {
>                     AlterUserMappingStmt *n = makeNode(AlterUserMappingStmt);
>                     n->user = $5;
>                     n->servername = $7;
>                     n->options = $8;
>                     n->if_not_exists = false;
>                     $$ = (Node *) n;
>                 }
>                 | CREATE USER MAPPING IF_P NOT EXISTS FOR auth_ident SERVER name create_generic_options
>                 {
>                     CreateUserMappingStmt *n = makeNode(CreateUserMappingStmt);
>                     n->user = $8;
>                     n->servername = $10;
>                     n->options = $11;
>                     n->if_not_exists = true;
>                     $$ = (Node *) n;
>                 }
>         ;

Here ALTER USER MAPPING and CREATE USER MAPPING commands were mixed.

-- 
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company