Re: [pgadmin-support] Error editing table WITH primary key

2009-01-18 Thread Michael Shapiro
7;Donnell [mailto:r...@iol.ie] >> Sent: Friday, January 16, 2009 4:17 PM >> To: Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] >> Cc: Terry Yapt; pgadmin-support@postgresql.org >> Subject: Re: [pgadmin-support] Error editing table WITH primary key >> >> O

Re: [pgadmin-support] Error editing table WITH primary key

2009-01-18 Thread Terry Yapt
ssage- > From: Raymond O'Donnell [mailto:r...@iol.ie] > Sent: Friday, January 16, 2009 4:17 PM > To: Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] > Cc: Terry Yapt; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Error editing table WITH prima

Re: [pgadmin-support] Error editing table WITH primary key

2009-01-16 Thread Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS]
Error editing table WITH primary key On 16/01/2009 18:56, Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] wrote: > 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 Is a prim

Re: [pgadmin-support] Error editing table WITH primary key

2009-01-16 Thread Raymond O'Donnell
On 16/01/2009 18:56, Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] wrote: > 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 Is a primary key not unique by definition? - doesn't the primary

Re: [pgadmin-support] Error editing table WITH primary key

2009-01-16 Thread Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS]
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. :-) G