Re: with and trigger
От
Tom Lane
Тема
Re: with and trigger
Дата
Msg-id
2699.1559143289@sss.pgh.pa.us
Ответ на
Re: with and trigger (Ron)
Список
Дерево обсуждения
with and trigger PegoraroF10 <marcos@f10.com.br>
Re: with and trigger Tom Lane <tgl@sss.pgh.pa.us>
Re: with and trigger Ron <ronljohnsonjr@gmail.com>
Re: with and trigger Tom Lane <tgl@sss.pgh.pa.us>
Re: with and trigger Andreas Kretschmer <andreas@a-kretschmer.de>
Re: with and trigger Geoff Winkless <pgsqladmin@geoff.dj>
Re: with and trigger PegoraroF10 <marcos@f10.com.br>
Re: with and trigger Fabrízio de Royes Mello <fabrizio@timbira.com.br>
Ron writes: > On 5/29/19 8:26 AM, Tom Lane wrote: >> This doesn't explicitly talk about triggers, but I think our attitude >> about the case you're discussing is that the results are unspecified. >> If a trigger fired in one WITH arm tries to look at the table(s) >> modified by other WITH arms, it might or might not see those changes. > Are CTEs still optimization fences? > https://www.2ndquadrant.com/en/blog/postgresql-ctes-are-optimization-fences/ Yes, if they contain data-modifying statements ... but that's not relevant to the point at hand, which is that the run-time behavior is not specified. regards, tom lane
В списке pgsql-general по дате отправления
От: Julie Nishimura
Дата:
