diff options
author | Joe Conway <mail@joeconway.com> | 2020-05-28 13:17:04 -0400 |
---|---|---|
committer | Joe Conway <mail@joeconway.com> | 2020-05-28 13:19:16 -0400 |
commit | 36758c472ea71dae96f4b495df65490413c79c83 (patch) | |
tree | 948904651f7500f792e9b49416e1ca7f212506bc | |
parent | 34301c9c5674919ef2e786f1157b3ced543b02e2 (diff) | |
download | postgresql-36758c472ea71dae96f4b495df65490413c79c83.tar.gz postgresql-36758c472ea71dae96f4b495df65490413c79c83.zip |
Add CHECK_FOR_INTERRUPTS() to the repeat() function
The repeat() function loops for potentially a long time without
ever checking for interrupts. This prevents, for example, a query
cancel from interrupting until the work is all done. Fix by
inserting a CHECK_FOR_INTERRUPTS() into the loop.
Backpatch to all supported versions.
Discussion: https://www.postgresql.org/message-id/flat/8692553c-7fe8-17d9-cbc1-7cddb758f4c6%40joeconway.com
-rw-r--r-- | src/backend/utils/adt/oracle_compat.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/backend/utils/adt/oracle_compat.c b/src/backend/utils/adt/oracle_compat.c index c827001ad31..2d94f8b0da5 100644 --- a/src/backend/utils/adt/oracle_compat.c +++ b/src/backend/utils/adt/oracle_compat.c @@ -19,7 +19,7 @@ #include "utils/builtins.h" #include "utils/formatting.h" #include "mb/pg_wchar.h" - +#include "miscadmin.h" static text *dotrim(const char *string, int stringlen, const char *set, int setlen, @@ -1062,6 +1062,7 @@ repeat(PG_FUNCTION_ARGS) { memcpy(cp, sp, slen); cp += slen; + CHECK_FOR_INTERRUPTS(); } PG_RETURN_TEXT_P(result); |