Segfault on updating foreign table

From: Lukáš Sobotka <sobotka(dot)luk(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Segfault on updating foreign table
Date: 2020-01-26 07:00:00
Message-ID: CAJif3k+iA_ekBB5Zw2hDBaE1wtiQa4LH4_JUXrrMGwTrH0J01Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
postgresql.log text/x-log 2.3 KB
reproducer.sql application/sql 1.3 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Deepak Rai 2020-01-26 07:12:51 Re: BUG #16232: Database server connection limit exceeding
Previous Message David G. Johnston 2020-01-26 06:56:53 Re: BUG #16230: Boolean column stick to "false" after calling updateRow() on updateable ResultSet