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:
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