]> git.ipfire.org Git - thirdparty/postgresql.git/commit
vacuumdb: Schema-qualify operator in catalog query's WHERE clause.
authorNathan Bossart <nathan@postgresql.org>
Mon, 7 Oct 2024 21:49:20 +0000 (16:49 -0500)
committerNathan Bossart <nathan@postgresql.org>
Mon, 7 Oct 2024 21:49:20 +0000 (16:49 -0500)
commiteba8cc1af8ec57aff99f11ef9cdf24a641c159b0
tree40a03b40cfed760e1d94e44e095c98dfc6ef3b8b
parent8aaf88b63de3d6e665b0fcf1ff123f08b961fe66
vacuumdb: Schema-qualify operator in catalog query's WHERE clause.

Commit 1ab67c9dfa, which modified this catalog query so that it
doesn't return temporary relations, forgot to schema-qualify the
operator.  A comment earlier in the function implores us to fully
qualify everything in the query:

 * Since we execute the constructed query with the default search_path
 * (which could be unsafe), everything in this query MUST be fully
 * qualified.

This commit fixes that.  While at it, add a newline for consistency
with surrounding code.

Reviewed-by: Noah Misch
Discussion: https://postgr.es/m/ZwQJYcuPPUsF0reU%40nathan
Backpatch-through: 12
src/bin/scripts/vacuumdb.c