medium5.4
CVE-2026-16237
PostgreSQL INSERT ... ON CONFLICT can read or modify rows despite auto-updatable view WHERE condition
Impact
Improper protection in PostgreSQL INSERT ... ON CONFLICT on auto-updatable views allows an attacker having INSERT and UPDATE privileges on the view to read and modify every row in the view's base table, via iterated INSERT ... ON CONFLICT DO UPDATE. This bypasses the view's WHERE condition, whether or not the view is a security_barrier view. Versions before PostgreSQL 18.7, 17.12, 16.16, 15.20, and 14.25 are affected.
An attacker can exploit this over the network, with a regular user account, without any action by a user. If it succeeds: low risk of data being read, low risk of data or systems being changed.
Affected products
| Product | Affected versions |
|---|---|
| PostgreSQL | from 18 before 18.7 from 17 before 17.12 from 16 before 16.16 from 15 before 15.20 before 14.25 |