| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Lukáš Sobotka <sobotka(dot)luk(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Segfault on updating foreign table |
| Date: | 2020-01-26 18:26:33 |
| Message-ID: | 12802.1580063193@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
=?UTF-8?B?THVrw6HFoSBTb2JvdGth?= <sobotka(dot)luk(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eduardo Lúcio Amorim Costa | 2020-01-26 20:43:55 | Re: SQL/PostgreSQL - Error observed in the QUERY not caught by the “EXCEPTION” block in the stored procedure |
| Previous Message | Tom Lane | 2020-01-26 16:28:18 | Re: BUG #16233: Yet another "logical replication worker" was terminated by signal 11: Segmentation fault |