| Re: deleted primary key can't be reused? [message #181844 is a reply to message #181843] |
Wed, 12 June 2013 05:52   |
Denis McMahon
Messages: 634
Registered: September 2010
Karma:
|
Senior Member |
|
|
On Tue, 11 Jun 2013 23:46:48 -0500, Gordon Burditt wrote:
> In other words, if the primary key for a record is "Mary Contrary",
> and you delete that, and the next record is "Michael Jackson", the
> primary key for that record should now become "Mary Contrary"?
I don't think that's what Richard is asking for.
What Richard wants to do is delete the record with primary key value of
x, and at a later date, insert a new record with the primary key value of
x.
The underlying problem here is that Richard created the table using some
combination of options that he read about on a web page 10 years ago, or
possibly chose using a random number generator of some sort, and whatever
options he had set the table concerned up with would not allow him to
reuse a deleted primary key value.
Richard being Richard he's miraculously solved the problem, which
probably means he's removed every attribute he can from the affected
column until he could make the change he wanted to make, and he may have
then put a random selection of attributes back on the table, some of
which might bear some resemblance to those he removed in the first place.
--
Denis McMahon, denismfmcmahon(at)gmail(dot)com
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]