Postgres Pro
Downloads
Home   >   mailing lists

Re: Segfault on updating foreign table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Segfault on updating foreign table
Date
Msg-id 12802.1580063193@sss.pgh.pa.us
Whole thread Raw
In response to Segfault on updating foreign table  (Lukáš Sobotka <sobotka.luk@gmail.com>)
List pgsql-bugs
Tree view 
=?UTF-8?B?THVrw6HFoSBTb2JvdGth?= <sobotka.luk@gmail.com> writes:
> 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
> );

Yup, that's a bug.  Will fix, thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16233: Yet another "logical replication worker" was terminated by signal 11: Segmentation fault
Next
From: Eduardo Lúcio Amorim Costa
Date:
Subject: Re: SQL/PostgreSQL - Error observed in the QUERY not caught by the “EXCEPTION” block in the stored procedure