Re: serial column
От | Bob Pawley |
---|---|
Тема | Re: serial column |
Дата | |
Msg-id | 009901c6e028$dda130c0$8e904618@owner обсуждение исходный текст |
Ответ на | serial column (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: serial column
|
Список | pgsql-general |
"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 ----- 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 3:19 PM Subject: Re: [GENERAL] serial column > On Sun, 2006-09-24 at 14:49 -0700, Bob Pawley wrote: >> It's the behavior I expect - but the gaps aren't acceptable. >> >> Bob > > Then using the SERIAL or SEQUENCE won't do you any good. > > 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 > > Another solution would be to have two triggers, one for delete and one > for insert plus an extra *reserve* table to reserve the deleted value. > The delete trigger would save the *deleted* values in the reserve table > and when a new record is inserted the insert trigger first would check > the reserve table for deleted values (that are stored by the delete > trigger) if a value exist then it would use that value or increment that > last value. > > However if you want to use a *no gap* sequence as a primary key, you > should be aware that you will destroy the integrity of you data. > > > > > -- > Regards, > Gevik Babakhani > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org >
В списке pgsql-general по дате отправления: