On Wed, Mar 20, 2024, at 7:16 AM, Shubham Khanna wrote: > On Tue, Mar 19, 2024 at 8:54 PM vignesh C <vignes...@gmail.com> wrote: > > > > If you are not planning to have the checks for name length, this could > > alternatively be fixed by including database id also while querying > > pg_subscription like below in set_replication_progress function: > > appendPQExpBuffer(str, > > "SELECT oid FROM pg_catalog.pg_subscription \n" > > "WHERE subname = '%s' AND subdbid = (SELECT oid FROM > > pg_catalog.pg_database WHERE datname = '%s')", > > dbinfo->subname, > > dbinfo->dbname); > > The attached patch has the changes to handle the same.
I included a different query that does the same. See v32. -- Euler Taveira EDB https://www.enterprisedb.com/
