auto-increment field resetting itself
От | Chris Calef |
---|---|
Тема | auto-increment field resetting itself |
Дата | |
Msg-id | 3990707B.70A43162@orcasinc.com обсуждение исходный текст |
Список | pgsql-general |
Hi. I tried to post this before but I never saw it come up, I apologize if it's a repost. Anyway, I'm having some weird behavior with a postgres (6.5) autoincrement fields. I have a field "users_id_seq" that is hooked to a sequence, when I add users I call nextval('users_id_seq') as you would expect, but every now and then (it's happened two or three times in the last few months, to give you and idea of frequency. Not every day, just often enough to forget about it) the sequence somehow gets stuck on a lower number than it should be on, and suddenly no new users can be added becasue it's trying to duplicate ids. I have not manually called "setval" or anything, but I can't guarantee that it didn't happen as some kind of side effect of work I was doing on it.. I always discover it days later so I don't know precisely what I was doing at the time that it happened. At least the last time it happened, I know I had not been altering the users table, though I had been adding fields to other tables. Does that ring any bells at all, with anyone? If I don't come up with some kind of answer there's going to be some people getting pretty pissed at me here, so any advice would be welcome!! TIA Chris Calef
В списке pgsql-general по дате отправления: