WITH NOT MATERIALIZED and DML CTEs

Поиск
Список
Период
Сортировка
От Elvis Pranskevichus
Тема WITH NOT MATERIALIZED and DML CTEs
Дата
Msg-id 7542836.7399EEAcVK@hammer.magicstack.net
обсуждение исходный текст
Ответы Re: WITH NOT MATERIALIZED and DML CTEs  (Andres Freund <andres@anarazel.de>)
Re: WITH NOT MATERIALIZED and DML CTEs  (David Fetter <david@fetter.org>)
Список pgsql-hackers
Currently, WITH a AS NOT MATERIALIZED (INSERT ...) would silently 
disregard the "NOT MATERIALIZED" instruction and execute the data-
modifying CTE to completion (as per the long-standing DML CTE rule).

This seems like an omission to me.  Ideally, the presence of an explicit 
"NOT MATERIALIZED" clause on a data-modifying CTE should disable the 
"run to completion" logic.

It is understandably late in the 12 cycle, so maybe prohibit NOT 
MATERIALIZED with DML altogheter and revisit this in 13?

Thoughts?

                               Elvis
 






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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Dead stores in src/common/sha2.c
Следующее
От: Andres Freund
Дата:
Сообщение: Re: WITH NOT MATERIALIZED and DML CTEs