From: | arden liu <ardenbook(at)gmail(dot)com> |
---|---|
To: | Daniel Verite <daniel(at)manitou-mail(dot)org> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: psql show me the : and ask user input, when running one sql file |
Date: | 2020-04-05 18:46:48 |
Message-ID: | CAK0KdkmQzPncEeZXze_UMLxZz3Yk87pyk0BCEhmPE4kAqBD2MQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)manitou-mail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2020-04-06 06:39:34 | Server with hot standby slave wont start after vacuum |
Previous Message | Daniel Verite | 2020-04-05 18:32:36 | Re: psql show me the : and ask user input, when running one sql file |