Re: serial column

Thanks

I'll give that a try.

Bob
----- Original Message -----
From: "Gevik Babakhani" <pgdev@xs4all.nl>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
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
>
>
>
>