William R. Mussatto wrote:
From an SQL point of view, shouldn't the existing primary key be replaced by another so that each row is ALWAYS uniquely addressable.Unique addressability is something that is not an inate property of all SQL tables; only ones that have UNIQUE or PRIMARY keys, so its not 'wrong' for a unique key to not exist while the table is in flux. If you want it to be wrong, simply wrap the operation in a transaction or possibly lock the table, although I'm not sure either of these actually applies to ALTERing the table (but they should, IMHO).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
