Re: How is this possible "publication does not exist" - Mailing list pgsql-bugs

From operations i
Subject Re: How is this possible "publication does not exist"
Date
Msg-id CANWRaJx=8wbORaBsiTxvxh6fUmi2WDDRZeWFF3FhJKw7pkUGkA@mail.gmail.com
Whole thread Raw
In response to How is this possible "publication does not exist"  (operations i <ioperations.c@gmail.com>)
Responses Re: How is this possible "publication does not exist"  (operations i <ioperations.c@gmail.com>)
List pgsql-bugs
after several times debugging, I 've realized the key point is the order of publication creation and insert statement, and both two have reached catcache.c:SearchCatCacheMiss() .and below has the difference explained
1. publication create first and then insert data into table
       the expression ```HeapTupleIsValid(ntp = systable_getnext(scandesc))``` return true

2.insert data into table and then create publication
      the expression ```HeapTupleIsValid(ntp = systable_getnext(scandesc))``` return false

so in case 2 , when decoding the first change , system table snapshot do not have Publication 'pub_test' , so throw the error
        " publication 'pub_test'" not exists 


pgsql-bugs by date:

Previous
From: Shaheed Haque
Date:
Subject: Re: Unable to make use of "deep" JSONB index
Next
From: operations i
Date:
Subject: Re: How is this possible "publication does not exist"