Received: from smtp.networkusa.net (smtp.networkusa.net [216.15.144.12]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBLFrC615938 for ; Thu, 21 Dec 2000 10:53:12 -0500 (EST) (envelope-from dalgoda@ix.netcom.com) Received: from ylum.mrc-home.org (109-62.bestdsl.net [216.162.109.62]) by smtp.networkusa.net (8.8.7/8.8.7) with ESMTP id KAA19549 for ; Thu, 21 Dec 2000 10:45:22 -0600 Received: from thune.mrc-home.org by ylum.mrc-home.org (8.10.0) id K1OFqdl24535; Sun, 24 Feb 1980 09:52:39 -0600 Received: by thune.mrc-home.org (8.10.0) id eBLFqv905114; Thu, 21 Dec 2000 09:52:57 -0600 Date: Thu, 21 Dec 2000 09:52:57 -0600 From: Mike Castle To: PostgreSQL-SQL Subject: Re: Invoice number Message-ID: <20001221095257.B5037@thune.mrc-home.org> Reply-To: Mike Castle Mail-Followup-To: Mike Castle , PostgreSQL-SQL References: <00122111100003.25042@bering> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.6i In-Reply-To: <00122111100003.25042@bering>; from kar@webline.dk on Thu, Dec 21, 2000 at 11:10:00AM +0100 X-Archive-Number: 200012/248 X-Sequence-Number: 585 On Thu, Dec 21, 2000 at 11:10:00AM +0100, Kaare Rasmussen wrote: > - Sequences are not rollback'able. Did you mean SERIAL instead of sequence here? If so, why is no rollbackable an issue? All you should need is unique numbers. Not necessarily exactly sequential numbers. mrc -- Mike Castle Life is like a clock: You can work constantly dalgoda@ix.netcom.com and be right all the time, or not work at all www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc We are all of us living in the shadow of Manhattan. -- Watchmen