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 views base table, via iterated INSERT … ON CONFLICT DO UPDATE. This bypasses the views 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.
The product does not sufficiently protect all possible paths that a user can take to access restricted functionality or resources.
| Name | Vendor | Start Version | End Version |
|---|---|---|---|
| Red Hat Hardened Images | RedHat | postgresql17-main-17.12-0.1.hum1 | * |
| Red Hat Hardened Images | RedHat | postgresql18-main-18.7-0.1.hum1 | * |
| Red Hat Hardened Images | RedHat | libpq-main-18.7-0.1.hum1 | * |
| Postgresql-10 | Ubuntu | upstream | * |
| Postgresql-12 | Ubuntu | upstream | * |
| Postgresql-9.3 | Ubuntu | upstream | * |
| Postgresql-9.5 | Ubuntu | upstream | * |