Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Trying to set constraint - new primary key in table, but getting an error: column "amgettuple" does not exist (pgadmin3)

I am creating a new table using pgadmin3 and when I click on constraints to add a primary key, I get this error:

enter image description here

I searched on google but I'm not finding this "amgettuple" issue. Does anyone know what this means? I am new to postgres and using pgadmin, just set it up an hour ago.

Postgres version: 9.6

pgadmin version: 1.22.2

linux mint 18

like image 871
user1354934 Avatar asked Dec 01 '16 06:12

user1354934


2 Answers

I am also using pgAdmin 3 and got that error. I fixed it by using the Query Tool:

ALTER TABLE table_name
ADD primary key (column_name);
like image 141
Virtual Ludo Avatar answered Nov 03 '22 13:11

Virtual Ludo


Install pgAdmin 4. pgAdmin III was supported up to 9,5 version I think.

like image 12
Lemjur Avatar answered Nov 03 '22 14:11

Lemjur