aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2022-07-31 12:29:44 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2022-07-31 12:29:44 -0400
commitbfac42ea0284f4608d1c37477db14374f4ac9e87 (patch)
tree0974a81663a4d8009bc8ce00463345e4448265ff
parent43231423dafc0cedcb52169465589b0d1d3c47d2 (diff)
downloadpostgresql-bfac42ea0284f4608d1c37477db14374f4ac9e87.tar.gz
postgresql-bfac42ea0284f4608d1c37477db14374f4ac9e87.zip
Make new auto_explain test safe for log_error_verbosity = verbose.
Allow for the possible presence of a SQLSTATE code in the expected warning message, similarly to b998196bb and 19408aae7 (although here I see no need to allow more than one specific SQLSTATE). Per gripe from Andrew Dunstan. Discussion: https://postgr.es/m/c550ac53-5db5-3958-1798-50bae3d9af71@dunslane.net
-rw-r--r--contrib/auto_explain/t/001_auto_explain.pl2
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/auto_explain/t/001_auto_explain.pl b/contrib/auto_explain/t/001_auto_explain.pl
index 7f394ed292b..54fa152cc08 100644
--- a/contrib/auto_explain/t/001_auto_explain.pl
+++ b/contrib/auto_explain/t/001_auto_explain.pl
@@ -172,7 +172,7 @@ GRANT SET ON PARAMETER auto_explain.log_format TO regress_user1;
like(
$log_contents,
- qr/WARNING: permission denied to set parameter "auto_explain\.log_level"/,
+ qr/WARNING: ( 42501:)? permission denied to set parameter "auto_explain\.log_level"/,
"permission failure logged");
} # end queries run as regress_user1