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

Поиск
Список
Период
Сортировка
От operations i
Тема Re: How is this possible "publication does not exist"
Дата
Msg-id CANWRaJx=8wbORaBsiTxvxh6fUmi2WDDRZeWFF3FhJKw7pkUGkA@mail.gmail.com
обсуждение исходный текст
Ответ на How is this possible "publication does not exist"  (operations i <ioperations.c@gmail.com>)
Ответы Re: How is this possible "publication does not exist"
Список 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 по дате отправления:

Предыдущее
От: Shaheed Haque
Дата:
Сообщение: Re: Unable to make use of "deep" JSONB index
Следующее
От: operations i
Дата:
Сообщение: Re: How is this possible "publication does not exist"