Re: psql \copy hanging - Mailing list pgsql-general

From Arnaud L.
Subject Re: psql \copy hanging
Date
Msg-id ce1dcc77-884e-d328-ea04-18a4aa374c51@codata.eu
Whole thread Raw
In response to Re: psql \copy hanging  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
Le 08/10/2019 à 12:55, Daniel Verite a écrit :
>     Arnaud L. wrote:
> 
>> As a side note, COPY (...) TO STDOUT \g 'somefile' does not work in a 
>> script file (i.e. it does not work if the command is passed in a file 
>> via the -f argument).
>> The command runs fine, no error is raised either by the client or the 
>> server, but no file is written.
> 
> Testing this with 11.5, it works for me.
> Make sure you're running the latest minor release (on the client
> side in this case), because a related fix was issued last February.
> For the 11 branch it was in version 11.2.


I'm on 11.5-1 on the client side, but I had added an output redirection 
for this batch file to try to understand what was happening during the 
night runs, and that might be the reason why \g fails (i.e. some 
interference between the console redirections).
I'll give it another try without these redirections.

Regards
--
Arnaud



pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: psql \copy hanging
Next
From: Andreas Kretschmer
Date:
Subject: Re: GPS coordinates problem