Search code examples
sqldmlpostgresql-9.6

I am trying to update a table on postgreSQL 9.6 and pg admin 4 and it is not updating/inserting

I am trying to update a table on postgreSQL 9.6 and pg admin 4 and it is not updating/inserting. Basically no write query is working, although it is working on that tab but when I open new tab try to see my changes, the changes are not there and data is same.

Simple sql query like update name or insert row, issue is not with SQL query.

Solution

  • In pgAdmin go to File -> Preferences -> SQL Editor. You probably have AutoCommit set to off. Either turn it on or add a "COMMIT" statement in order to see the effect in other tabs.