Thanks
I'll give that a try.
Bob
----- Original Message -----
From: "Gevik Babakhani" <pgdev@xxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Sunday, September 24, 2006 4:13 PM
Subject: Re: [GENERAL] serial column
On Sun, 2006-09-24 at 15:29 -0700, Bob Pawley wrote:
"A possible solution for this would be to regenerate the entire column's
values every time a record gets deleted starting form 1. but then again
this would be very slow if you have a very large table"
I don't anticipate the table to be more than a few hundred rows -
certainly
fewer than 1,000.
Could you point to some documentation for regenerating a column's values
other than manual??
Bob
I am afraid there is no built-in way to do that.
perhaps you could create a function that:
step1: creates a sequence (with random name)....
step2: update table set field=netval('random_seq_name');
step3: drop sequence...
--
Regards,
Gevik Babakhani
