Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 185624759B0 for ; Thu, 22 Aug 2002 08:44:01 -0400 (EDT) Received: from new-smtp2.ihug.com.au (new-smtp2.ihug.com.au [203.109.250.28]) by postgresql.org (Postfix) with ESMTP id 224924759A1 for ; Thu, 22 Aug 2002 08:44:00 -0400 (EDT) Received: from p473-tnt2.mel.ihug.com.au (postgresql.org) [203.173.165.219] by new-smtp2.ihug.com.au with esmtp (Exim 3.22 #1 (Debian)) id 17hrJh-0004Fi-00; Thu, 22 Aug 2002 22:44:01 +1000 Message-ID: <3D64DC8B.CCA7D984@postgresql.org> Date: Thu, 22 Aug 2002 22:43:55 +1000 From: Justin Clift X-Mailer: Mozilla 4.79 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Keary Suska Cc: Postgres-PHP Subject: Re: Nextval Problems References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/69 X-Sequence-Number: 1414 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