Top
Enterprise Postgres 14 SP1 Messages
FUJITSU Software

2.65.74 16875

materialized views must not use data-modifying statements in WITH

[Description]

Prohibit a data-modifying CTE in the query used to create a materialized view. It's not sufficiently clear what the user would want to happen if the MV is refreshed or incrementally maintained.

[System Processing]

Processing will be aborted.

[Action]

To investigate the cause of the occurrence from the message, and remove cause.