Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 71770475DA5; Thu, 22 Aug 2002 15:49:04 -0400 (EDT) Received: from chico.machine.net (217-126-36-116.uc.nombres.ttd.es [217.126.36.116]) by postgresql.org (Postfix) with ESMTP id 9AF24475D8E; Thu, 22 Aug 2002 15:49:02 -0400 (EDT) Received: from win2000 ([192.168.0.10]) by chico.machine.net (8.9.3/8.9.3/SuSE Linux 8.9.3-0.1) with SMTP id WAA02619; Thu, 22 Aug 2002 22:18:44 GMT Message-ID: <002901c24a16$3c05bc60$0a00a8c0@win2000> From: "Simeo Reig" To: "Justin Clift" , "Keary Suska" Cc: "Postgres-PHP" References: <3D64DC8B.CCA7D984@postgresql.org> Subject: Re: Nextval Problems Date: Thu, 22 Aug 2002 21:58:07 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/76 X-Sequence-Number: 1421 curval() or currval() can't remember Best Regards Simeo Reig ----- Original Message ----- From: "Justin Clift" To: "Keary Suska" Cc: "Postgres-PHP" Sent: Thursday, August 22, 2002 2:43 PM Subject: Re: [PHP] Nextval Problems > Hi Keary, > > Keary Suska wrote: > > > 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@postgresql.org) >