Re: serial column
От | Bob Pawley |
---|---|
Тема | Re: serial column |
Дата | |
Msg-id | 00d701c6e031$8a9c3470$8e904618@owner обсуждение исходный текст |
Ответ на | serial column (Bob Pawley <rjpawley@shaw.ca>) |
Список | pgsql-general |
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 > > > >
В списке pgsql-general по дате отправления: