Re: Error editing table WITH primary key

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(dot)m(dot)thornton(at)nasa(dot)gov <mailto:susan(dot)m(dot)thornton(at)nasa(dot)gov>

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Terry Yapt
Sent: Friday, January 16, 2009 7:08 AM
To: pgadmin-support(at)postgresql(dot)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