Re: Foreign table & Connection reset by peer

2019-02-24 Thread Adrian Klaver
On 2/24/19 2:25 AM, Lukáš Sobotka wrote: Thanks for quick answer. I am feeling a little embarrassed that I did not find this before... The thread definitely helped me to understand more. When I execute query with foreign tables, the connection is created (according pg_stat_activity). The quest

Re: Foreign table & Connection reset by peer

2019-02-24 Thread Lukáš Sobotka
Thanks for quick answer. I am feeling a little embarrassed that I did not find this before... The thread definitely helped me to understand more. When I execute query with foreign tables, the connection is created (according pg_stat_activity). The question is what I should do for ending the connec

Re: Foreign table & Connection reset by peer

2019-02-23 Thread Adrian Klaver
On 2/23/19 1:28 PM, Lukáš Sobotka wrote: Hi guys, I would be grateful for some advice about foreign tables. I attached simplified script describing the problem for better understanding. What I am trying to do: I am copying tables between two databases and for copying is used function which

Foreign table & Connection reset by peer

2019-02-23 Thread Lukáš Sobotka
Hi guys, I would be grateful for some advice about foreign tables. I attached simplified script describing the problem for better understanding. What I am trying to do: I am copying tables between two databases and for copying is used function which are called from bash script. What is problem: