Re: psql \copy hanging

Поиск
Список
Период
Сортировка
От Arnaud L.
Тема Re: psql \copy hanging
Дата
Msg-id ce1dcc77-884e-d328-ea04-18a4aa374c51@codata.eu
обсуждение исходный текст
Ответ на Re: psql \copy hanging  ("Daniel Verite" <daniel@manitou-mail.org>)
Список 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 по дате отправления:

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: psql \copy hanging
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: GPS coordinates problem