Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4

2016-11-29 Thread Melvin Davidson
ber 29, 2016 5:14 PM Subject: Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4 Ok, I am not trying to be difficult. I am trying to understand. If that sounds defensive, it's because of prior experience on Stack Overflow, where the "experts" tend to be snarky, IMHO. I did all

Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4

2016-11-29 Thread Malik Rumi
gt; > Melvin Davidson > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > www.youtube.com/unusedhero/videos > Folk Alley - All Folk - 24 Hours a day > www.folkalley.com > > > > ---------- &

Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4

2016-11-29 Thread Melvin Davidson
ubject: Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4 Thank you. However... ERROR: current transaction is aborted, commands ignored until end of transaction block I'm not even sure what this means. Which transaction is it referring to? The rollback or the update? What is the err

Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4

2016-11-29 Thread Malik Rumi
Thank you. However... ERROR: current transaction is aborted, commands ignored until end of transaction block I'm not even sure what this means. Which transaction is it referring to? The rollback or the update? What is the error and how do I fix it? What is meant by "*until* end of transaction blo

Re: [pgadmin-support] ROLLBACK syntax error in pgadmin4

2016-11-29 Thread Melvin Davidson
The problem is, ROLLBACK requires a transaction. So to use it properly you need to start with a BEGIN statement. eg: BEGIN;your_statements;ROLLBACK; https://www.postgresql.org/docs/9.4/static/sql-begin.html https://www.postgresql.org/docs/9.4/static/sql-rollback.html fyi, in the future, it is a