Re: pg15 beta2 bug:cause by logcial replation
От | Tom Lane |
---|---|
Тема | Re: pg15 beta2 bug:cause by logcial replation |
Дата | |
Msg-id | 568157.1656652619@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | RE: pg15 beta2 bug:cause by logcial replation ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>) |
Список | pgsql-bugs |
"houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com> writes: > On Friday, July 1, 2022 11:35 AM 396934406@qq.com <396934406@qq.com> wrote: >> ERROR: could not receive list of replicated tables from the publisher: ERROR: column t.attnames does not exist >> LINE 2: , t.attnames > Just to confirm, did you use the PG15 beta1 or earlier PG15 version > as the publisher and use PG15 beta2 as the subscriber ? It looks to me like this was an attempt to replicate from 15beta1 to 15beta2, which would fail because commit fd0b9dceb imagines that any server reporting version >= 15 will have pg_publication_tables.attnames, even though that column was not there in beta1. I bitched about the ill-timing of that schema change at the time but was outvoted. At this point I think it's water over the dam. We could perhaps change that test in fetch_table_list(), but it'd require access to the source server's catversion, which I don't think is readily available. In any case, by the time we could provide a fix it'd be useless to testers of beta1; they'd have updated already by some other method. regards, tom lane
В списке pgsql-bugs по дате отправления: