{"schemaVersion":3,"id":"CVE-2016-5423","aliases":["UBUNTU-CVE-2016-5423"],"status":"published","duplicateOf":null,"title":null,"description":"PostgreSQL before 9.1.23, 9.2.x before 9.2.18, 9.3.x before 9.3.14, 9.4.x before 9.4.9, and 9.5.x before 9.5.4 allow remote authenticated users to cause a denial of service (NULL pointer dereference and server crash), obtain sensitive memory information, or possibly execute arbitrary code via (1) a CASE expression within the test value subexpression of another CASE or (2) inlining of an SQL function that implements the equality operator used for a CASE expression involving values of different types.","dates":{"published":"2016-12-09T23:00:00.000Z","modified":"2024-08-06T01:00:59.955Z","reserved":null,"kevAdded":[],"kevDue":[]},"cvss":{"headline":{"score":8.3,"severity":"high","version":"3.0","versionLabel":"v3.0","source":"NVD","vector":"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:H/A:H","computed":false,"selection":"backend-summary"},"metrics":[{"version":"3.0","versionLabel":"v3.0","source":"NVD","score":8.3,"severity":"high","vector":"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:H/A:H","exploitability":null,"impact":null,"computed":false},{"version":"2.0","versionLabel":"v2.0","source":"NVD","score":6.5,"severity":"medium","vector":"AV:N/AC:L/Au:S/C:P/I:P/A:P","exploitability":null,"impact":null,"computed":false},{"version":"3.0","versionLabel":"v3.0","source":"OSV · Ubuntu","score":8.3,"severity":"high","vector":"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:H/A:H","exploitability":7.2,"impact":9.2,"computed":true}]},"epss":{"probability":0.05962,"percentile":0.93216,"severity":"low","asOf":"2026-10-19T00:00:00.000Z","change":{"pp":0,"baselineDate":"2026-09-19T00:00:00.000Z","baselineScore":0.05962},"history":[{"date":"2026-09-14T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-15T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-16T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-17T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-18T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-19T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.05924,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.05962,"percentile":0.93216}],"last30":[{"date":"2026-09-19T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-20T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-21T00:00:00.000Z","score":0.05924,"percentile":null},{"date":"2026-09-22T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-23T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-24T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-25T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-26T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-27T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-28T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-29T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-09-30T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-01T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-02T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-03T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-04T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-05T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-06T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-07T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-08T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-09T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-10T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-11T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-12T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-13T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-14T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-15T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-16T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-17T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-18T00:00:00.000Z","score":0.05962,"percentile":null},{"date":"2026-10-19T00:00:00.000Z","score":0.05962,"percentile":0.93216}]},"kev":{"state":"not-listed","entries":[],"listedCount":0,"totalCatalogs":3,"catalogs":[{"source":"cisa","label":"CISA","listed":false,"entry":null},{"source":"enisa","label":"ENISA","listed":false,"entry":null},{"source":"circl","label":"CIRCL","listed":false,"entry":null}]},"ransomware":{"state":"none-recorded","sources":[]},"exploits":[],"exploitCount":0,"weaknesses":[{"id":"CWE-476","name":"NULL Pointer Dereference","description":"The product dereferences a pointer that it expects to be valid but is NULL.","type":"weakness","status":"Stable","abstraction":"Base","likelihoodOfExploit":"Medium","url":"https://cwe.mitre.org/data/definitions/476.html"}],"affected":[{"vendor":"ubuntu","product":"postgresql-9.1","name":"postgresql-9.1","label":"postgresql-9.1","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/postgresql-9.1","purlType":"deb","versions":[{"text":"< 9.1.23-0ubuntu0.14.04","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 9.1.23-0ubuntu0.14.04","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"postgresql-9.3","name":"postgresql-9.3","label":"postgresql-9.3","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/postgresql-9.3","purlType":"deb","versions":[{"text":"< 9.3.14-0ubuntu0.14.04","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 9.3.14-0ubuntu0.14.04","eol":null,"hubHref":null},{"vendor":"ubuntu","product":"postgresql-9.5","name":"postgresql-9.5","label":"postgresql-9.5","ecosystem":"Ubuntu","cpePart":null,"purl":"pkg:deb/ubuntu/postgresql-9.5","purlType":"deb","versions":[{"text":"< 9.5.4-0ubuntu0.16.04","noFixRecorded":false,"fixedIn":null}],"versionsText":"< 9.5.4-0ubuntu0.16.04","eol":null,"hubHref":null},{"vendor":"debian","product":"debian_linux","name":"debian linux","label":"debian_linux","ecosystem":null,"cpePart":"o","purl":null,"purlType":null,"versions":[{"text":"8.0","noFixRecorded":false,"fixedIn":null}],"versionsText":"8.0","eol":{"isEol":true,"eolDate":"2020-06-30T00:00:00.000Z","matchMethod":"cpe","cycle":{"name":"8","label":"8 (Jessie)","eolFrom":"2020-06-30T00:00:00.000Z","isLts":false,"isMaintained":false,"latestVersion":"8.11"},"product":{"name":"debian","label":"Debian","category":"os"}},"hubHref":"/vendor/debian/debian_linux"},{"vendor":"postgresql","product":"postgresql","name":"postgresql","label":"postgresql","ecosystem":null,"cpePart":"a","purl":null,"purlType":null,"versions":[{"text":"≤ 9.1.22","noFixRecorded":false,"fixedIn":null},{"text":"9.2","noFixRecorded":false,"fixedIn":null},{"text":"9.2.1","noFixRecorded":false,"fixedIn":null},{"text":"9.2.2","noFixRecorded":false,"fixedIn":null},{"text":"9.2.3","noFixRecorded":false,"fixedIn":null},{"text":"9.2.4","noFixRecorded":false,"fixedIn":null},{"text":"9.2.5","noFixRecorded":false,"fixedIn":null},{"text":"9.2.6","noFixRecorded":false,"fixedIn":null},{"text":"9.2.7","noFixRecorded":false,"fixedIn":null},{"text":"9.2.8","noFixRecorded":false,"fixedIn":null},{"text":"9.2.9","noFixRecorded":false,"fixedIn":null},{"text":"9.2.10","noFixRecorded":false,"fixedIn":null},{"text":"9.2.11","noFixRecorded":false,"fixedIn":null},{"text":"9.2.12","noFixRecorded":false,"fixedIn":null},{"text":"9.2.13","noFixRecorded":false,"fixedIn":null},{"text":"9.2.14","noFixRecorded":false,"fixedIn":null},{"text":"9.2.15","noFixRecorded":false,"fixedIn":null},{"text":"9.2.16","noFixRecorded":false,"fixedIn":null},{"text":"9.2.17","noFixRecorded":false,"fixedIn":null},{"text":"9.3","noFixRecorded":false,"fixedIn":null},{"text":"9.3.1","noFixRecorded":false,"fixedIn":null},{"text":"9.3.2","noFixRecorded":false,"fixedIn":null},{"text":"9.3.3","noFixRecorded":false,"fixedIn":null},{"text":"9.3.4","noFixRecorded":false,"fixedIn":null},{"text":"9.3.5","noFixRecorded":false,"fixedIn":null},{"text":"9.3.6","noFixRecorded":false,"fixedIn":null},{"text":"9.3.7","noFixRecorded":false,"fixedIn":null},{"text":"9.3.8","noFixRecorded":false,"fixedIn":null},{"text":"9.3.9","noFixRecorded":false,"fixedIn":null},{"text":"9.3.10","noFixRecorded":false,"fixedIn":null},{"text":"9.3.11","noFixRecorded":false,"fixedIn":null},{"text":"9.3.12","noFixRecorded":false,"fixedIn":null},{"text":"9.3.13","noFixRecorded":false,"fixedIn":null},{"text":"9.4","noFixRecorded":false,"fixedIn":null},{"text":"9.4.1","noFixRecorded":false,"fixedIn":null},{"text":"9.4.2","noFixRecorded":false,"fixedIn":null},{"text":"9.4.3","noFixRecorded":false,"fixedIn":null},{"text":"9.4.4","noFixRecorded":false,"fixedIn":null},{"text":"9.4.5","noFixRecorded":false,"fixedIn":null},{"text":"9.4.6","noFixRecorded":false,"fixedIn":null},{"text":"9.4.7","noFixRecorded":false,"fixedIn":null},{"text":"9.4.8","noFixRecorded":false,"fixedIn":null},{"text":"9.5","noFixRecorded":false,"fixedIn":null},{"text":"9.5.1","noFixRecorded":false,"fixedIn":null},{"text":"9.5.2","noFixRecorded":false,"fixedIn":null},{"text":"9.5.3","noFixRecorded":false,"fixedIn":null}],"versionsText":"≤ 9.1.22 | 9.2 | 9.2.1 | 9.2.2 | 9.2.3 | 9.2.4 | 9.2.5 | 9.2.6 | 9.2.7 | 9.2.8 | 9.2.9 | 9.2.10 | 9.2.11 | 9.2.12 | 9.2.13 | 9.2.14 | 9.2.15 | 9.2.16 | 9.2.17 | 9.3 | 9.3.1 | 9.3.2 | 9.3.3 | 9.3.4 | 9.3.5 | 9.3.6 | 9.3.7 | 9.3.8 | 9.3.9 | 9.3.10 | 9.3.11 | 9.3.12 | 9.3.13 | 9.4 | 9.4.1 | 9.4.2 | 9.4.3 | 9.4.4 | 9.4.5 | 9.4.6 | 9.4.7 | 9.4.8 | 9.5 | 9.5.1 | 9.5.2 | 9.5.3","eol":{"isEol":true,"eolDate":"2017-11-09T00:00:00.000Z","matchMethod":"cpe","cycle":{"name":"9.2","label":"9.2","eolFrom":"2017-11-09T00:00:00.000Z","isLts":false,"isMaintained":false,"latestVersion":"9.2.24"},"product":{"name":"postgresql","label":"PostgreSQL","category":"database"}},"hubHref":"/vendor/postgresql/postgresql"}],"affectedCount":5,"eol":{"hasEol":true,"count":2},"references":[{"url":"http://rhn.redhat.com/errata/RHSA-2016-1781.html","label":"rhn.redhat.com/errata/RHSA-2016-1781.html","hostname":"rhn.redhat.com","tags":["Vendor Advisory","X Refsource REDHAT"]},{"url":"https://www.postgresql.org/docs/current/static/release-9-4-9.html","label":"www.postgresql.org/docs/current/static/release-9-4-9.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM","Release Notes","Vendor Advisory"]},{"url":"http://www.securitytracker.com/id/1036617","label":"www.securitytracker.com/id/1036617","hostname":"www.securitytracker.com","tags":["VDB Entry","X Refsource SECTRACK","Third Party Advisory"]},{"url":"http://rhn.redhat.com/errata/RHSA-2016-1821.html","label":"rhn.redhat.com/errata/RHSA-2016-1821.html","hostname":"rhn.redhat.com","tags":["Vendor Advisory","X Refsource REDHAT"]},{"url":"http://www.debian.org/security/2016/dsa-3646","label":"www.debian.org/security/2016/dsa-3646","hostname":"www.debian.org","tags":["Vendor Advisory","X Refsource DEBIAN","Third Party Advisory"]},{"url":"http://www.securityfocus.com/bid/92433","label":"www.securityfocus.com/bid/92433","hostname":"www.securityfocus.com","tags":["VDB Entry","X Refsource BID","Third Party Advisory"]},{"url":"https://security.gentoo.org/glsa/201701-33","label":"security.gentoo.org/glsa/201701-33","hostname":"security.gentoo.org","tags":["Vendor Advisory","X Refsource GENTOO"]},{"url":"https://access.redhat.com/errata/RHSA-2017:2425","label":"access.redhat.com/errata/RHSA-2017:2425","hostname":"access.redhat.com","tags":["Vendor Advisory","X Refsource REDHAT"]},{"url":"https://www.postgresql.org/docs/current/static/release-9-5-4.html","label":"www.postgresql.org/docs/current/static/release-9-5-4.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM","Release Notes","Vendor Advisory"]},{"url":"https://www.postgresql.org/docs/current/static/release-9-3-14.html","label":"www.postgresql.org/docs/current/static/release-9-3-14.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM","Release Notes","Vendor Advisory"]},{"url":"https://www.postgresql.org/about/news/1688/","label":"www.postgresql.org/about/news/1688/","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM","Patch","Vendor Advisory","REPORT"]},{"url":"https://www.postgresql.org/docs/current/static/release-9-2-18.html","label":"www.postgresql.org/docs/current/static/release-9-2-18.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM","Release Notes","Vendor Advisory"]},{"url":"http://rhn.redhat.com/errata/RHSA-2016-2606.html","label":"rhn.redhat.com/errata/RHSA-2016-2606.html","hostname":"rhn.redhat.com","tags":["Vendor Advisory","X Refsource REDHAT"]},{"url":"http://rhn.redhat.com/errata/RHSA-2016-1820.html","label":"rhn.redhat.com/errata/RHSA-2016-1820.html","hostname":"rhn.redhat.com","tags":["Vendor Advisory","X Refsource REDHAT"]},{"url":"https://www.postgresql.org/docs/current/static/release-9-1-23.html","label":"www.postgresql.org/docs/current/static/release-9-1-23.html","hostname":"www.postgresql.org","tags":["X Refsource CONFIRM","Release Notes","Vendor Advisory"]},{"url":"https://bugzilla.redhat.com/show_bug.cgi?id=1364001","label":"bugzilla.redhat.com/show_bug.cgi?id=1364001","hostname":"bugzilla.redhat.com","tags":["X Refsource CONFIRM","Issue Tracking","Third Party Advisory","VDB Entry"]},{"url":"https://ubuntu.com/security/CVE-2016-5423","label":"ubuntu.com/security/CVE-2016-5423","hostname":"ubuntu.com","tags":["REPORT"]},{"url":"https://ubuntu.com/security/notices/USN-3066-1","label":"ubuntu.com/security/notices/USN-3066-1","hostname":"ubuntu.com","tags":["Advisory"]},{"url":"https://www.cve.org/CVERecord?id=CVE-2016-5423","label":"www.cve.org/CVERecord?id=CVE-2016-5423","hostname":"www.cve.org","tags":["REPORT"]}],"lineage":{"upstream":[],"downstream":["DLA-592-1","DSA-3646-1","MGASA-2016-0289","OPENSUSE-SU-2024:10030-1","OPENSUSE-SU-2024:10256-1","OPENSUSE-SU-2024:10273-1","RHSA-2016:1781","RHSA-2016:1820","RHSA-2016:1821","RHSA-2016:2606","RHSA-2017:2425","SUSE-SU-2016:2414-1","SUSE-SU-2016:2415-1","SUSE-SU-2016:2418-1","USN-3066-1"],"duplicates":[],"related":["OPENSUSE-SU-2024:10030-1","OPENSUSE-SU-2024:10256-1","OPENSUSE-SU-2024:10273-1","SUSE-SU-2016:2414-1","SUSE-SU-2016:2415-1","SUSE-SU-2016:2418-1","USN-3066-1"]},"timeline":[{"kind":"published","date":"2016-12-09T23:00:00.000Z","label":"Published","detail":"Vulnerability first disclosed.","source":null},{"kind":"modified","date":"2024-08-06T01:00:59.955Z","label":"Last modified","detail":"Vulnerability information updated.","source":null}],"risk":{"score":34,"level":"medium","profile":"Default","thresholds":{"critical":75,"high":50,"medium":25,"low":10}},"meta":{"dataAsOf":"2026-10-20T04:34:38.209Z","stale":false,"partial":false}}