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. :-)
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.thorn...@nasa.gov <mailto:susan.m.thorn...@nasa.gov>
________________________________
From: pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@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
