Menu ▾ ▴

#3544 Error message about PRIMARY key

3.4.0
out-of-date
nobody
Interface (555)
1
2013-06-11
2012-03-30
Rob Lewis
No

When I click the "edit" pencil on my PRIMARY key on a simple table, a message in a red box says
("PRIMARY" must be the name of and only of a primary key!)
Well, it is. The PRIMARY index is defined on a column called "time_stamp", which is, surprisingly, a timestamp. The index name and index type are both "PRIMARY". Nothing fancy about it. The time_stamp field is defined as CURRENT_TIMESTAMP, not NULL.
Everything seems to work OK. So what is this error message all about? I have never attempted to create records with the same timestamp.
Using MySQL 5.5, Safari on Mac OS 10.7.3.

Discussion

  • Rouslan Placella

    Rouslan Placella - 2012-03-30

    There is no error. It's just that one of the PMA programmers used a message of type "error".
    This has been fixed in the upcoming version 3.5.0 and the message is now of type "notice".

     

  • Rouslan Placella

    Rouslan Placella - 2012-03-30
    • labels: 2681263 --> Interface
    • priority: 5 --> 1
    • status: open --> closed-out-of-date
     

  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-out-of-date --> out-of-date