Ultimate

X_ENTITY_VIEW_READ_ONLY

Means

a view entity was asked to write a row

Typical cause

insert, update, upsert or delete reached an entity declared with view: { sql }, which is a relation Postgres derives and no row can be written to

Fix

db.<source>.insert(row) — write the table the view reads; the view answers it on the next read (materialized: after refreshView runs)

Listed under Entity and database

This page as markdown