Re: insert aborted commands ignored

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: insert aborted commands ignored
Date: 2019-01-31 20:57:30
Message-ID: B2382FDA-B68E-4ABD-8C5D-BC6AF5278713@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jan 31, 2019, at 1:35 PM, Pepe TD Vo <pepevo(at)yahoo(dot)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 entered it, followed by the first line of output? Because there IS an earlier error, and you need to find it.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2019-01-31 20:59:54 Re: Old WAL files under pg_xlog not getting delete
Previous Message Pepe TD Vo 2019-01-31 20:35:04 Re: insert aborted commands ignored