Re: Incorrect messages emitted from pgoutput when using column lists

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Incorrect messages emitted from pgoutput when using column lists
Дата
Msg-id Y4AuHx6ZwGyKll1Z@paquier.xyz
обсуждение исходный текст
Ответ на RE: Incorrect messages emitted from pgoutput when using column lists  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
Ответы RE: Incorrect messages emitted from pgoutput when using column lists
Список pgsql-bugs
On Fri, Nov 25, 2022 at 02:46:46AM +0000, houzj.fnst@fujitsu.com wrote:
> I think the reason is that we didn't filter the column when sending the old
> tuple in pgoutput. We thought that the old tuple won't include columns that not
> in RI, but it seems it will still be null values for such columns in the old
> tuple. So, I think we'd better filter the column for old tuple as well.

Isn't that something where you should have at least some coverage with
one or more regression tests?
--
Michael

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "houzj.fnst@fujitsu.com"
Дата:
Сообщение: RE: Incorrect messages emitted from pgoutput when using column lists
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit