Re: insert aborted commands ignored - Mailing list pgsql-admin

From Scott Ribe
Subject Re: insert aborted commands ignored
Date
Msg-id B2382FDA-B68E-4ABD-8C5D-BC6AF5278713@elevated-dev.com
Whole thread Raw
In response to Re: insert aborted commands ignored  (Pepe TD Vo <pepevo@yahoo.com>)
List pgsql-admin
> On Jan 31, 2019, at 1:35 PM, Pepe TD Vo <pepevo@yahoo.com> wrote:
>
> $ psql -U postgres -d CIDR < insert.sql > insert_cidrmgmt.txt
>
> I got all repeat error .....
> "ERROR: current transaction is aborted, commands ignored until  end of transaction block "

Is it possible you're not seeing output because your scrollback buffer is limited? Can you see the command as you
enteredit, followed by the first line of output? Because there IS an earlier error, and you need to find it. 

pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: insert aborted commands ignored
Next
From: "David G. Johnston"
Date:
Subject: Re: Old WAL files under pg_xlog not getting delete