Hi Terry,
Is your primary key defined as “Unique”? If this is the case, you may be trying to add a value for the key that already exists. Or it may be defined as “not null) and you may be trying to insert a row with a null primary key.
I hope it’s as simple as this for you. J
Good luck!
Sue Walker-Thornton
Sue Walker-Thornton
ConITS Contract
NASA Langley Research Center
Integrated Library Systems Application & Database Administrator
130 Research Drive
Hampton, VA 23666
Office: (757) 224-4074
Fax: (757) 224-4001
Pager: (757) 988-2547
Email: susan.m.thornton@nasa.gov
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Terry Yapt
Sent: Friday, January 16, 2009 7:08 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Error editing table WITH primary key
Hello all,
I have installed PostgreSQL 8.3.5 and PgAdmin 1.8.4 - Rev.7358.
I have populated a recent database inserting all SQL command on pgadmin a SQL-window. Tables shows right constraints PRIMARY KEY, but when I try to edit table data a warning message with the title "Edit table data without primary key" is showed and I cannot insert data on that tables.
If I create a table from inside PgAdmin then all goes ok.
Any idea what is the problem ?
Greetings.
--
Terry Yapt