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 <dan...@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 >
