Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to unlock columns in pgAdmin

Tags:

pgadmin

unlock

I want to unlock the columns which appearing in the following pic:

https://i.sstatic.net/3F7cb.png

I know that the answer is make id a primary key. but the problem here is that I can't make id a primary key because there are two rows empty in id column and I can't delete these rows because the column locked! Please try to help me. Thank you very much

like image 584
Fofah Avatar asked Oct 17 '25 11:10

Fofah


2 Answers

You cannot update or delete rows if you don't have primary key. That is the reason they're locked. It's impossible to identify rows uniquely for update/delete queries to run.

like image 123
Aditya Toshniwal Avatar answered Oct 21 '25 00:10

Aditya Toshniwal


It happens when we have not turn on the primary key on our column of any which we want to make primary key . just go to the properties of the table and turn on the primary key of your column which you want to make primary key.

like image 20
Prabhudatta Sahu Avatar answered Oct 20 '25 23:10

Prabhudatta Sahu