Re: Record SET session in VariableSetStmt

Поиск
Список
Период
Сортировка
Искать
От
Julien Rouhaud
Тема
Re: Record SET session in VariableSetStmt
Дата
Msg-id
20221006111812.xogzmp3wzmstvuav@jrouhaud
Ответ на
Список
Дерево обсуждения
Record SET session in VariableSetStmt "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
Re: Record SET session in VariableSetStmt Julien Rouhaud <rjuju123@gmail.com>
Re: Record SET session in VariableSetStmt "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
Re: Record SET session in VariableSetStmt Julien Rouhaud <rjuju123@gmail.com>
Re: Record SET session in VariableSetStmt "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
Re: Record SET session in VariableSetStmt Michael Paquier <michael@paquier.xyz>
Re: Record SET session in VariableSetStmt Julien Rouhaud <rjuju123@gmail.com>
Hi,

On Thu, Oct 06, 2022 at 12:57:17PM +0200, Drouvot, Bertrand wrote:
> Hi hackers,
>
> "SET local" is currently recorded in VariableSetStmt (with the boolean
> is_local) but "SET session" is not.
>
> Please find attached a patch proposal to also record "SET session" so that
> VariableSetStmt records all the cases.
>
> Remark: Recording "SET session" will also help for the Jumbling work being
> done in [1].

I don't think it's necessary.  SET and SET SESSION are semantically the same so
nothing should rely on how exactly someone spelled it.  This is also the case
for our core jumbling code, where we guarantee (or at least try to) that two
semantically identical statements will get the same queryid, and therefore
don't distinguish eg. LIKE vs ~~.


В списке pgsql-hackers по дате отправления
От: Drouvot, Bertrand
Дата:
От: Michael Paquier
Дата:
FAQ