Re: Record SET session in VariableSetStmt

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Record SET session in VariableSetStmt
Дата
Msg-id 20221007033303.ucpqmlqr66rqy6vg@jrouhaud
обсуждение исходный текст
Ответ на Re: Record SET session in VariableSetStmt  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Fri, Oct 07, 2022 at 10:30:28AM +0900, Michael Paquier wrote:
> On Thu, Oct 06, 2022 at 08:28:27PM +0800, Julien Rouhaud wrote:
> > If we move to a real jumbling of VariableSetStmt, we should keep the rules
> > consistent with the rest of the jumble code and ignore an explicit "SESSION" in
> > the original command.
> 
> Hm, interesting bit, I should study more this area.  So the query ID
> calculation actually only cares about the contents of the Nodes
> parsed, while the query string used is the one when the entry is
> created for the first time.  It seems like the patch to add
> TransactionStmt nodes into the jumbling misses something here, as we'd
> still compile different query IDs depending on the query string itself
> for simple commands like BEGIN or COMMIT.  I'll reply on the other
> thread about all that..

Ah, indeed we have different TransactionStmtKind for BEGIN and START!



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: use has_privs_of_role() for pg_hba.conf
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Query Jumbling for CALL and SET utility statements