Re: psql show me the : and ask user input, when running one sql file

Поиск
Список
Период
Сортировка
От arden liu
Тема Re: psql show me the : and ask user input, when running one sql file
Дата
Msg-id CAK0KdkmQzPncEeZXze_UMLxZz3Yk87pyk0BCEhmPE4kAqBD2MQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql show me the : and ask user input, when running one sql file  ("Daniel Verite" <daniel@manitou-mail.org>)
Список pgsql-general
Дерево обсуждения
Hi Daniel,
"-P pager=off" works!!!! I think you found the root cause.

Thanks for your help.
Arden

On Sun, Apr 5, 2020 at 2:32 PM Daniel Verite <daniel@manitou-mail.org> wrote:
        Adrian Klaver wrote:

> On 4/5/20 9:46 AM, Adrian Klaver wrote:
> > On 4/5/20 5:50 AM, arden liu wrote:
>
> > 4) I don't see anything wrong the statements, so I am wondering if it is
> > a shell issue?
>
> Seems to be. I removed the RETURNING *_id from the INSERT statements and
> the file ran without interruption:

Presumably these results are being displayer with a pager, and it's
the pager that is asking for keyboard input.
You may add -P pager=off to psql options to suppress this,
or remove permanently the RETURNING clauses that seem pointless
in that context.


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

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

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: psql show me the : and ask user input, when running one sql file
Следующее
От: "Andrus"
Дата:
Сообщение: Server with hot standby slave wont start after vacuum