PgAdmin 4: Cannot edit rows from one table

postgresql pgadmin pgadmin-4
Camilo Ortegón picture Camilo Ortegón · Sep 11, 2017 · Viewed 20.8k times · Source

Something strange is happening with my new created tables in Postgres, I can add data to them, but I cannot use PgAdmin to edit the any row.

This is my table columns description:

Table columns

After executing the query to view all table rows this is what I can see:

Right click at the table

At the Data Output

Save button is disabled to update my table rows. But this is happening only with my new created tables, as you can see, I have other tables where I'm able to edit rows, for example at this table of Users:

Other table that is able to edit data

Answer

Camilo Ortegón picture Camilo Ortegón · Sep 11, 2017

Found the problem! That was happening, because I didn't select any of the columns as 'Primary key':

Table columns description updated

Related questions

PGAdmin: Not connected to the server or the connection to the server has been closed

i got this problem with postgreSQL, when i do a simple query of anything (CRUD), sometimes it works and almost always shows this message: Not connected to the server or the connection to the server has been closed. I don't …

Read More
PgAdmin fatal error. The appllication server could not be contacted

A couple of days before I have installed on my PC with Windows 7 Professional new version of PgAdmin (version 4). It worked fine, but today it loads slowly and then information window appears with text: "PgAdmin fatal error. The appllication server …

Read More
Postgresql Transaction ID Not Found

Whenever I am executing a query in postgresql, this is the error message I receive Transaction ID not found in the session. Does anyone have any idea how to resolve this? I recently created a new user, but I was …

Read More