PostgreSQL ERROR: current transaction is aborted, commands ignored until end of transaction block
Writing by shivdev on Tuesday, 7 of September , 2010 at 4:03 pm
After opening up PostgreSQL to accept connections from the outside world and using SQLExplorer as a client, I noticed that if there was a SQL Syntax error or any problem with a SQL, any following SQL statement would come back with
ERROR: current transaction is aborted, commands ignored until end of transaction block
Simple fix for me was to rollback the transaction
rollback
It’s likely that my client was somehow starting a BEGIN transaction and since the query wasn’t valid, the transaction didn’t end so had to manually rollback.
Leave a comment
Category: Tips and Tricks
- Add this post to
- Del.icio.us -
- Digg -
- -
- Tweet -
-
-
No Comments
No comments yet.
Leave a comment
You must be logged in to post a comment.
