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

2016-11-29 Thread Melvin Davidson
Malik, I was not blaming you for posting to PgAdmin, I was just trying to advise you and direct you to the proper forum. Please do not be so defensive. As to determining whether it is a PgAdmin error or a PostgreSQL error, that is pretty simple. If a "feature" of PgAdmin is not working properly

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

2016-11-29 Thread Malik Rumi
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 of this in PGAdmin4, so that is why I posted here. How would I determine what is a PGAdmin4 issue and

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

2016-11-29 Thread Melvin Davidson
Malik, First things first.1. This is not the correct forum for this problem. PgAdmin is a utility for managing PostgreSQL. You are better off re-submitting this problem to pgsql-general@postgresql.orgbut you stand a better chance if you also includeA. O/SB. Exact version of PostgreSQLC. SQL code

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

[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

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-11-29 Thread Peter Juhasz
On Tue, 2016-11-29 at 03:07 +0300, Devrim Gündüz wrote: > Hi, > > On Wed, 2016-11-23 at 14:12 +0100, Peter Juhasz wrote: > > > > I've installed the latest pgadmin4-v1 package from the PGDG > > repository. > > Unfortunately, it still does not work. > > > > Is this a fresh installation, or did y

[pgadmin-support] PgAdmin4 not usable when installed from RPMs on Fedora linux

2016-11-29 Thread Kieran McCusker
Hi I'm having the same problem. I did install the earlier RPMs but removed them (and any mention I could find of pgAdmin4) before reinstalling. Thanks Kieran -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresq