PgAdmin 4: Cannot edit rows from one table

43.9k views Asked by At

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

2

There are 2 answers

1
Camilo Ortegón On BEST ANSWER

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

Table columns description updated

0
Akaisteph7 On

My issue was that I was doing a join and pgAdmin didn't like that. I had to query the table directly.