From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | DUVAL REMI <REMI(dot)DUVAL(at)cheops(dot)fr> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: proposal: schema variables |
Date: | 2020-03-13 18:44:33 |
Message-ID: | CAFj8pRDnxjje-FAc9bRFtt3Di=ZhGi6DOVAEZnHDesfR8zmN-Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
Hi
ne 8. 3. 2020 v 19:12 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
napsal:
>
>
> so 7. 3. 2020 v 22:15 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> napsal:
>
>> Hi
>>
>> I fixed the some ugly parts of this patch - now the LET x = DEFAULT, LET
>> x = NULL is processed by more usual way.
>> Statement LET is doesn't switch between STMT_UTILITY and
>> STMT_PLAN_UTILITY like before. It is only STMT_PLAN_UTILITY statement.
>>
>
> I did some cleaning - I mainly replaced CMD_PLAN_UTILITY by CMD_LET
> because there is not another similar statement in queue.
>
another cleaning - I repleaced CMD_LET by CMD_SELECT_UTILITY. This name is
more illustrative, and little bit cleaned code.
CMD_SELECT_UTILITY is mix of CMD_SELECT and CMD_UTILITY. It allows PREPARE
and parametrizations like CMD_SELECT. But execution is like CMD_UTILITY by
own utility routine with explicit dest receiver setting. This design
doesn't need to introduce new executor and planner nodes (like ModifyTable
and ModifyTablePath).
Regards
Pavel
> Regards
>
> Pavel
>
>
>> Regards
>>
>> Pavel
>>
>
Attachment | Content-Type | Size |
---|---|---|
schema-variables-20200313.patch.gz | application/gzip | 65.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2020-03-13 18:44:42 | Re: Berserk Autovacuum (let's save next Mandrill) |
Previous Message | James Coleman | 2020-03-13 18:23:10 | Re: [PATCH] Incremental sort (was: PoC: Partial sort) |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2020-03-18 05:58:30 | Re: proposal: schema variables |
Previous Message | Justin Pryzby | 2020-03-12 20:43:36 | Re: Slow ext'd query via client native implementation vs. libpq & simple psql |