Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9CGnlf03109 for ; Fri, 12 Oct 2001 12:49:47 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 146731; Fri, 12 Oct 2001 09:49:44 -0700 From: "Josh Berkus" Subject: Re: Nextval To: Zavier Sheran , pgsql-php@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Fri, 12 Oct 2001 09:49:44 -0700 Message-ID: In-Reply-To: <20011012015510.73010.qmail@web14402.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200110/64 X-Sequence-Number: 617 Zavier, In the future, cross-post this sort of request to pgsql-novice. More of us DB Engine / Query Parser developers subscribe to that list than this one. > Fetch a SERIAL field (ie. record_id) and get the > highest value currently stored (ie. 1000), increment > the value by 1 and store a record that will have the > same value (1001) in record_id. So there must be a way > with concurrency control. > > I went through the manuals and found the solution with > NEXTVAL('serial'), but you have to create a sequence > for that, and I don't know if it is the right way to > do for what I want. Well, that depends on what you want to do, don't it? How about describing what you're trying to accomplish rather than making us guess? :-) -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco