Segfault on updating foreign table

Поиск
Список
Период
Сортировка
От Lukáš Sobotka
Тема Segfault on updating foreign table
Дата
Msg-id CAJif3k+iA_ekBB5Zw2hDBaE1wtiQa4LH4_JUXrrMGwTrH0J01Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Segfault on updating foreign table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
Hi there,

I tried to synchronize two tables on different databases using foreign data wrapper. I executed update of foreign table with sub-query selection from local table. As the result I got segmentation fault. General query:
UPDATE foreign_table SET (col) = (
    SELECT col
        FROM local_table
        WHERE foreign_table.id = local_table.id
);

I am not looking for working or better solution, I just want let you know about this. I think the query is according documentation and segfault is not suitable result. If somebody could check it I would be grateful.

For reproducer or log see attachments.
Tested on Ubuntu 18.04.3 LTS with PG12: PostgreSQL 12.1 (Ubuntu 12.1-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit

Thanks for your time.

Best regards,
Lukas
Вложения

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #16230: Boolean column stick to "false" after callingupdateRow() on updateable ResultSet
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16233: Yet another "logical replication worker" was terminated by signal 11: Segmentation fault