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