Re: [HACKERS] COPY FROM STDIN behaviour on end-of-file

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: [HACKERS] COPY FROM STDIN behaviour on end-of-file
Дата
Msg-id CAEepm=05PwS=Ad00DXLTt_cS-T+CdeLksmB9NihZXhGLkX5g3w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] COPY FROM STDIN behaviour on end-of-file  (Vaishnavi Prabakaran <vaishnaviprabakaran@gmail.com>)
Ответы Re: [HACKERS] COPY FROM STDIN behaviour on end-of-file  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, May 16, 2017 at 6:29 PM, Vaishnavi Prabakaran
<vaishnaviprabakaran@gmail.com> wrote:
> On Tue, May 16, 2017 at 8:40 AM, Thomas Munro
> <thomas.munro@enterprisedb.com> wrote:
>>
>>
>> I you hit ^d while COPY FROM STDIN is reading then subsequent COPY
>> FROM STDIN commands return immediately.
>
>
> Hi, I could not reproduce this issue. Even after Ctrl+d , subsequent COPY
> from commands reads the input properly. Is there any specific step you
> followed or can you share the sample testcase?

Hmm.  Doesn't happen on GNU/Linux, does happen on macOS and FreeBSD.  Example:

postgres=# create table t(a int);
CREATE TABLE
postgres=# copy t(a) from stdin;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> 42
>> [...press ^d here ...]COPY 1
postgres=# copy t(a) from stdin;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> COPY 0

-- 
Thomas Munro
http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: amul sul
Дата:
Сообщение: Re: [HACKERS] [POC] hash partitioning
Следующее
От: tushar
Дата:
Сообщение: [HACKERS] synchronous_commit option is not visible after pressing TAB