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.
| Affected Version | Fixed In | Fix Published |
|---|---|---|
| 18 | 18.7 | 2026-11-12 |
| 17 | 17.12 | 2026-11-12 |
| 16 | 16.16 | 2026-11-12 |
| 15 | 15.20 | 2026-11-12 |
| 14 | 14.25 | 2026-11-12 |
For more information about PostgreSQL versioning, please visit the versioning page.
| Overall Score | 5.4 |
|---|---|
| Component | core server |
| Vector | AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N |
If you wish to report a new security vulnerability in PostgreSQL, please send an email to security@postgresql.org.
For reporting non-security bugs, please see the Report a Bug page.