curval() or currval() can't remember Best Regards Simeo Reig ----- Original Message ----- From: "Justin Clift" <justin@xxxxxxxxxxxxxx> To: "Keary Suska" <hierophant@xxxxxxxxxx> Cc: "Postgres-PHP" <pgsql-php@xxxxxxxxxxxxxx> Sent: Thursday, August 22, 2002 2:43 PM Subject: Re: [PHP] Nextval Problems > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx) >
