Hi Keary, Keary Suska wrote: <snip> > So--I don't see much wrong. If you make the changes I recommend, and you are > still experiencing the problem, there is still something wrong with your > code. Probably in the parts you don't show us. Once had a *weird* problem with PG 7.0.? whereby it was incrementing by 2 for every invocation of nextval(), even though I was the only client - a single connection with psql - and the increment value of the sequence was definitely 1. Can't remember how I fixed it for sure, but think it was something along the lines of dropping the sequence and creating it again (manually). Have a feeling that many triggers or constraints turned out to be involved, but can't remember for sure. Definitely don't think this is a common occurance though. Regards and best wishes, Justin Clift > Keary Suska > Esoteritech, Inc. > "Leveraging Open Source for a better Internet" > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
