Transaction issue - Mailing list pgsql-general

From Rich Shepard
Subject Transaction issue
Date
Msg-id b77e58b-dd8c-373b-2a25-9eb224488e8b@appl-ecosys.com
Whole thread Raw
Responses Re: Transaction issue
Re: Transaction issue
Re: Transaction issue
List pgsql-general
I now insert rows using a transaction. Sometimes psql halts with an error:
ERROR:  current transaction is aborted, commands ignored until end of transaction block

I issue a rollback; command but cannot continue processing. What is the
appropriate way to respond to that error after fixing the syntax error?

TIA,

Rich



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Proper format for pg_dump file date
Next
From: Adrian Klaver
Date:
Subject: Re: Transaction issue