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
the PostgreSQL > version.* > > 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 > <http://www.youtube.com/unusedhero/videos> > Folk Alley - All Folk - 24 Hours a

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
gt; > ---------- > *From:* Malik Rumi > *To:* pgAdmin Support > *Sent:* Tuesday, November 29, 2016 1:17 PM > *Subject:* [pgadmin-support] ROLLBACK syntax error in pgadmin4 > > I am using PGAdmin4 with PG 9.4 on Ubuntu 16.04 64 bit. I wanted to do an >

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

2016-11-29 Thread Melvin Davidson
From: Malik Rumi To: pgAdmin Support Sent: Tuesday, November 29, 2016 1:17 PM Subject: [pgadmin-support] ROLLBACK syntax error in pgadmin4 I amusing PGAdmin4 with PG 9.4 on Ubuntu 16.04 64 bit. I wanted to do an update, but was unsureof the result, so I unselected autocommit and ran

[pgadmin-support] ROLLBACK syntax error in pgadmin4

2016-11-29 Thread Malik Rumi
I am using PGAdmin4 with PG 9.4 on Ubuntu 16.04 64 bit. I wanted to do an update, but was unsure of the result, so I unselected autocommit and ran explain. It said only one row was affected, which I didn’t understand, because it should have affected at least 2. Then I inferred that the ‘one row’ be