Skip to content

CVE-2026-16237 PostgreSQL INSERT ... ON CONFLICT can read or modify rows despite auto-updatable view WHERE condition

MediumCVSS 5.4 EPSS 0.27%
Published
Updated
Exploit status
No public exploit known
Technology
UbuntuDebianRed Hat

Description

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 products

ProductAffected versionsFixed in
alpine/postgresql15(Alpine:v3.21) < 15.20-r0 15.20-r0
alpine/postgresql15(Alpine:v3.22) < 15.20-r0 15.20-r0
alpine/postgresql16(Alpine:v3.21) < 16.16-r0 16.16-r0
alpine/postgresql16(Alpine:v3.22) < 16.16-r0 16.16-r0
alpine/postgresql16(Alpine:v3.23) < 16.16-r0 16.16-r0
alpine/postgresql16(Alpine:v3.24) < 16.16-r0 16.16-r0
alpine/postgresql17(Alpine:v3.21) < 17.12-r0 17.12-r0
alpine/postgresql17(Alpine:v3.22) < 17.12-r0 17.12-r0
alpine/postgresql17(Alpine:v3.23) < 17.12-r0 17.12-r0
alpine/postgresql17(Alpine:v3.24) < 17.12-r0 17.12-r0
alpine/postgresql18(Alpine:v3.23) < 18.7-r0 18.7-r0
alpine/postgresql18(Alpine:v3.24) < 18.7-r0 18.7-r0
debian/postgresql-15(Debian:12) < 15.20-0+deb12u1 15.20-0+deb12u1
debian/postgresql-15(Debian:12) = 15.10-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.11-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.12-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.12-0+deb12u2 No fix listed
debian/postgresql-15(Debian:12) = 15.13-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.14-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.15-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.16-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.17-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.18-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.19-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.3-0+deb12u1 No fix listed
Show 66 more
ProductAffected versionsFixed in
debian/postgresql-15(Debian:12) = 15.3-1 No fix listed
debian/postgresql-15(Debian:12) = 15.4-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.4-1 No fix listed
debian/postgresql-15(Debian:12) = 15.4-2 No fix listed
debian/postgresql-15(Debian:12) = 15.4-3 No fix listed
debian/postgresql-15(Debian:12) = 15.5-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.6-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.7-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.8-0+deb12u1 No fix listed
debian/postgresql-15(Debian:12) = 15.9-0+deb12u1 No fix listed
debian/postgresql-17(Debian:13) < 17.12-0+deb13u1 17.12-0+deb13u1
debian/postgresql-17(Debian:13) = 17.10-0+deb13u1 No fix listed
debian/postgresql-17(Debian:13) = 17.11-0+deb13u1 No fix listed
debian/postgresql-17(Debian:13) = 17.5-1 No fix listed
debian/postgresql-17(Debian:13) = 17.6-0+deb13u1 No fix listed
debian/postgresql-17(Debian:13) = 17.6-1 No fix listed
debian/postgresql-17(Debian:13) = 17.7-0+deb13u1 No fix listed
debian/postgresql-17(Debian:13) = 17.8-0+deb13u1 No fix listed
debian/postgresql-17(Debian:13) = 17.9-0+deb13u1 No fix listed
debian/postgresql-18(Debian:14) < 18.7-1 18.7-1
debian/postgresql-18(Debian:14) = 18.0-1 No fix listed
debian/postgresql-18(Debian:14) = 18.1-1 No fix listed
debian/postgresql-18(Debian:14) = 18.1-2 No fix listed
debian/postgresql-18(Debian:14) = 18.2-1 No fix listed
debian/postgresql-18(Debian:14) = 18.3-1 No fix listed
debian/postgresql-18(Debian:14) = 18.4-1 No fix listed
debian/postgresql-18(Debian:14) = 18.6-1 No fix listed
debian/postgresql-18(Debian:14) = 18.6-2 No fix listed
debian/postgresql-18(Debian:14) = 18.6-3 No fix listed
debian/postgresql-18(Debian:14) = 18~beta1+20250612-1 No fix listed
debian/postgresql-18(Debian:14) = 18~beta1+20250624-1 No fix listed
debian/postgresql-18(Debian:14) = 18~beta1+20250701-1 No fix listed
debian/postgresql-18(Debian:14) = 18~beta1-1 No fix listed
debian/postgresql-18(Debian:14) = 18~beta2-1 No fix listed
debian/postgresql-18(Debian:14) = 18~beta3-1 No fix listed
debian/postgresql-18(Debian:14) = 18~rc1-1 No fix listed
debian/postgresql-18(Debian:14) = 18~rc1-2 No fix listed
debian/postgresql-18(Debian:14) = 18~rc1-3 No fix listed
debian/postgresql-18(Debian:14) = 18~~devel.20250318+g4078da6c478-1 No fix listed
debian/postgresql-18(Debian:14) = 18~~devel.20250331-1 No fix listed
debian/postgresql-18(Debian:14) = 18~~devel.20250405-1 No fix listed
debian/postgresql-18(Debian:14) = 18~~devel.20250421-1 No fix listed
debian/postgresql-18(Debian:14) = 18~~devel.20250502-1 No fix listed
redhat/postgresql17-main(Red Hat:hummingbird:1) < 17.12-0.1.hum1 17.12-0.1.hum1
redhat/postgresql18-main(Red Hat:hummingbird:1) < 18.7-0.1.hum1 18.7-0.1.hum1
redhat/libpq-main(Red Hat:hummingbird:1) < 18.7-0.1.hum1 18.7-0.1.hum1
redhat/postgresql16(Red Hat:enterprise_linux:10) All versions No fix listed
redhat/postgresql18(Red Hat:enterprise_linux:10) All versions No fix listed
redhat/postgresql(Red Hat:rhel_els:6) All versions No fix listed
redhat/postgresql(Red Hat:rhel_els:7) All versions No fix listed
redhat/postgresql:12/postgresql(Red Hat:enterprise_linux:8) All versions No fix listed
redhat/postgresql:15/postgresql(Red Hat:enterprise_linux:8) All versions No fix listed
redhat/postgresql:16/postgresql(Red Hat:enterprise_linux:8) All versions No fix listed
redhat/postgresql(Red Hat:enterprise_linux:9) All versions No fix listed
redhat/postgresql:15/postgresql(Red Hat:enterprise_linux:9) All versions No fix listed
redhat/postgresql:16/postgresql(Red Hat:enterprise_linux:9) All versions No fix listed
redhat/postgresql:18/postgresql(Red Hat:enterprise_linux:9) All versions No fix listed
redhat/hi/postgresql(Red Hat:hummingbird:1) All versions No fix listed
redhat/ansible-automation-platform/bootc-automation-portal-rhel9(Red Hat:ansible_portal:2) All versions No fix listed
azure linux postgresql17(Azure Linux:4.0) All versions No fix listed
azure linux postgresql18(Azure Linux:4.0) All versions No fix listed
azure linux postgresql(Azure Linux:3.0) All versions No fix listed
ubuntu/postgresql-14(Ubuntu:22.04) All versions No fix listed
ubuntu/postgresql-16(Ubuntu:24.04) All versions No fix listed
ubuntu/postgresql-18(Ubuntu:26.04) All versions No fix listed
ubuntu/postgresql-18(Ubuntu:26.10) All versions No fix listed

References