Re: pgsql: Trial fix for old cross-version upgrades. - Mailing list pgsql-committers

From Andrew Dunstan
Subject Re: pgsql: Trial fix for old cross-version upgrades.
Date
Msg-id 3ac2cb7b-d0a7-4954-9e7a-97853d855df0@dunslane.net
Whole thread Raw
In response to Re: pgsql: Trial fix for old cross-version upgrades.  (Sami Imseih <samimseih@gmail.com>)
Responses Re: pgsql: Trial fix for old cross-version upgrades.
List pgsql-committers
On 2025-02-28 Fr 2:29 PM, Sami Imseih wrote:
> My perl expertise is bit shallow, but I could not find much
> regarding bugs related to such behavior, or maybe I did not
> look enough.
>
> Playing around with this, "s+", "s{1,}", s{2,}" all of these combinations
> where we are searching for more than 1 space result in the hanging command,
> but we really only need to look for a single space before the 'version',
> so maybe we can just do the below, which works?
>
> -       $dump =~ s {(^\s+'version',) '\d+'::integer,$}
> +      $dump =~ s {(^\s{1}'version',) '\d+'::integer,$}
>


Just noting here that \s{1} is simply the same as \s


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com




pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pgsql: Refactor COPY FROM to use format callback functions.
Next
From: Sami Imseih
Date:
Subject: Re: pgsql: Trial fix for old cross-version upgrades.