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
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
>
>
>
> ----------
&
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
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
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