Received: from cr322781-a.ym1.on.wave.home.com (cr322781-a.ym1.on.wave.home.com [24.112.37.89]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0C3c3p78825 for ; Thu, 11 Jan 2001 22:38:03 -0500 (EST) (envelope-from svanegmond@bang.dhs.org) Received: from svanegmond by cr322781-a.ym1.on.wave.home.com with local (Exim 3.20 #1 (Debian)) id 14Gv5r-0008Ga-00; Thu, 11 Jan 2001 22:41:35 -0500 Date: Thu, 11 Jan 2001 22:41:35 -0500 To: GH Cc: svanegmond@home.com, "Julio Cuz, Jr." , pgsql-php@postgresql.org Subject: Re: Automatic increment Message-ID: <20010111224135.A31773@bang.dhs.org> Reply-To: svanegmond@home.com References: <4.3.2.7.2.20010111190805.00b4b6a0@rccd.cc.ca.us> <20010111222205.A31717@bang.dhs.org> <20010111212523.A76845@over-yonder.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010111212523.A76845@over-yonder.net>; from grasshacker@over-yonder.net on Thu, Jan 11, 2001 at 09:25:23PM -0600 From: Stephen van Egmond X-Archive-Number: 200101/46 X-Sequence-Number: 111 GH (grasshacker@over-yonder.net) wrote: > I believe that it is commonly preferred to do: > select nextval('sequence'); > insert into foo (foo_id,...) values (, ...); Many people do the first SELECT on a form, stuff the result in a hidden variable, then do the INSERT in the form's handler. This prevents the double- (or triple-) clicking of "submit" resulting in extra database inserts.