sequence problem
От | gabi munteanu |
---|---|
Тема | sequence problem |
Дата | |
Msg-id | F242ekzabtneqdGSyMp00007bbe@hotmail.com обсуждение исходный текст |
Ответы |
Re: sequence problem
Re: sequence problem |
Список | pgsql-sql |
I have the following problem. I have a table [friends] and it looks like this: id serial name varchar(25) phone varchar(15) After I created it tehre is also a sequence that generates me the ids friens_id_seq Let's say I have 5 records. If I remove the 3th my ids will be 1,2,4,5 and my friends_id_seq=5. if I remove the 5th my ids will be 1,2,4 and my friends_id_seq=5. I want the following: if I remove a record my ids should always be like this: 1,2,3,4... and not 1,2,4,5,9,... I made a trigger that does my friends_id_seq = max(id) after delete. Can anyone help me? Thanx in advance _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
В списке pgsql-sql по дате отправления: