#17 primary key with multiple columns

closed-invalid
nobody
None
5
2010-11-13
2005-11-21
Anonymous
No

Bad for Version 1.2.1
good in Version 1.2.0

Tables with primary key defined on multiple columns
shown as an error if you try to add an additional column.

Example:

first:
CREATE TABLE import (zeile integer NOT NULL, prokey
integer NOT NULL, hash varchar NOT NULL, kav varchar
NOT NULL, line varchar NOT NULL, PRIMARY
KEY(zeile,kav), UNIQUE(Zeile,kav) );

second:
try to add a new field/column.

mr.migu

Discussion

  • You cant have a double primary keys as this is against SQL structure. You can only have 1(one) primary key in a table but multiple keys that are not primary.

    Not a bug but user issue. Please see SQL table structure and Primary Key's.

     
    • labels: 556733 -->
    • status: open --> closed-invalid