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
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
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
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
