Received: from snigglefritz.expressus.com (dhcphost11.expressus.com [64.114.34.80]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2QLRWw67834 for ; Mon, 26 Mar 2001 16:27:32 -0500 (EST) (envelope-from jkakar@expressus.com) Received: (from jkakar@localhost) by snigglefritz.expressus.com (8.11.2/8.11.1/Debian 8.11.0-6) id f2QLRSP15979 for pgsql-sql@postgresql.org; Mon, 26 Mar 2001 13:27:28 -0800 From: jkakar@expressus.com Date: Mon, 26 Mar 2001 13:27:28 -0800 To: pgsql-sql@postgresql.org Subject: serial type; race conditions Message-ID: <20010326132728.A15965@expressus.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.12i X-Archive-Number: 200103/539 X-Sequence-Number: 2209 Hi, I'm using serial fields to generate IDs for almost all object in my database. I insert an empty row, get the CURRVAL() of the sequence and then update to that value. I had understood (and now, I can't find the reference to back this up) that serial is implemented in such a way that race conditions between DB connections can't happen. Is this true? Thanks, Jamu. -- Jamu Kakar (Developer) Expressus Design Studio, Inc. jkakar@expressus.com 708-1641 Lonsdale Avenue V: (604) 903-6994 North Vancouver, BC, V7M 2J5