Re: How is this possible "publication does not exist"

Ok, I have got the real problem, It's very kind of you for your quick
response.

On Thu, Jun 2, 2022 at 6:58 PM operations i <ioperations(dot)c(at)gmail(dot)com> wrote:

> cool , you have send faster than me for about 5 seconds
>
> On Thu, Jun 2, 2022 at 6:57 PM operations i <ioperations(dot)c(at)gmail(dot)com>
> wrote:
>
>> 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
>>
>>
>>