Sorry - my bad. Here is the postgresql definition of a PRIMARY-KEY: The PRIMARY KEY column constraint specifies that a column of a table may contain only unique (non-duplicate), non-NULL values. The definition of the specified column does not have to include an explicit NOT NULL constraint to be included in a PRIMARY KEY constraint.
Sue -----Original Message----- 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 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 primary key not unique by definition? - doesn't the primary key uniquely identify a row in a table? Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
