]> git.ipfire.org Git - thirdparty/postgresql.git/commit
refint: Fix SQL injection and buffer overruns.
authorNathan Bossart <nathan@postgresql.org>
Mon, 11 May 2026 12:13:52 +0000 (05:13 -0700)
committerNoah Misch <noah@leadboat.com>
Mon, 11 May 2026 12:13:52 +0000 (05:13 -0700)
commit2b026df29c1e1caafb259a2021528a28ec484018
treeaf4adab9d47da536071521d88fe766269d47cec7
parent8ac723b2bc992fd86b09ae73c7c610242c4c037e
refint: Fix SQL injection and buffer overruns.

Maliciously crafted key value updates could achieve SQL injection
within check_foreign_key().  To fix, ensure new key values are
properly quoted and escaped in the internally generated SQL
statements.  While at it, avoid potential buffer overruns by
replacing the stack buffers for internally generated SQL statements
with StringInfo.

Reported-by: Nikolay Samokhvalov <nik@postgres.ai>
Author: Nathan Bossart <nathandbossart@gmail.com>
Reviewed-by: Noah Misch <noah@leadboat.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Security: CVE-2026-6637
Backpatch-through: 14
contrib/spi/refint.c