Re: Error editing table WITH primary key

["Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS]" <Susan(dot)M(dot)Thornton(at)nasa(dot)gov>]

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