postgresql - delete a row that is created by django using PHPPgAdmin? -
using django, added new entry table. want delete using phppgadmin (postgresql), no unique identifier row error. problem?
django automatically adds auto-incrementing primary key, cannot figure out issue is?
i read this post, did not help. if notice image carefully, see primary key column label id not pk should in django.

edit: no primary key seen on table; 
but django executes;
python manage.py sql auth
create table "auth_user" ( "id" serial not null primary key, "password" varchar(128) not null, "last_login" timestamp time zone not null, "is_superuser" boolean not null, "username" varchar(30) not null unique, "first_name" varchar(30) not null, "last_name" varchar(30) not null, "email" varchar(75) not null, "is_staff" boolean not null, "is_active" boolean not null, "date_joined" timestamp time zone not null ) ; edit: screenshot phppgadmin, showing id primary key 
i think bug phppgadmin.
i experienced similar problem , went directly psql (using command ./manage.py dbshell).
i tried deleting row in question, , received more helpful error message 1 phppgadmin. (in case, row being referenced table.)
i deleted row referenced other table, , able delete row in question.
Comments
Post a Comment