Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #9795

Re: deleted primary key can't be reused?

Show all headers | View raw

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@gmail.com

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

deleted primary key can't be reused? richard <noreply@example.com> - 2013-06-08 10:24 -0400
  Re: deleted primary key can't be reused? richard <noreply@example.com> - 2013-06-08 10:57 -0400
  Re: deleted primary key can't be reused? Luuk <luuk@invalid.lan> - 2013-06-08 17:46 +0200
  Re: deleted primary key can't be reused? The Natural Philosopher <tnp@invalid.invalid> - 2013-06-08 18:47 +0100
  Re: deleted primary key can't be reused? Norman Peelman <npeelman@cfl.rr.com> - 2013-06-08 15:32 -0400
  Re: deleted primary key can't be reused? gordonb.ps993@burditt.org (Gordon Burditt) - 2013-06-11 23:46 -0500
    Re: deleted primary key can't be reused? Denis McMahon <denismfmcmahon@gmail.com> - 2013-06-12 05:52 +0000
  Re: deleted primary key can't be reused? Doug Miller <doug_at_milmac_dot_com@example.com> - 2013-06-12 11:05 +0000
  Re: deleted primary key can't be reused? GravyCode <matty023@gmail.com> - 2013-06-21 10:25 -0700
    Re: deleted primary key can't be reused? gordonb.tuxls@burditt.org (Gordon Burditt) - 2013-06-23 04:05 -0500
      Re: deleted primary key can't be reused? The Natural Philosopher <tnp@invalid.invalid> - 2013-06-23 12:05 +0100
  Re: deleted primary key can't be reused? Marc van Lieshout <invalid@example.com> - 2013-06-21 19:52 +0200

csiph-web