Received: from courier02.adinet.com.uy (courier02.adinet.com.uy [206.99.44.245]) by hub.org (8.10.1/8.10.1) with ESMTP id e5L5Lv175921 for ; Wed, 21 Jun 2000 01:21:57 -0400 (EDT) Received: from adinet.com.uy (haroldo@r207-50-240-248.adinet.com.uy [207.50.240.248]) by courier02.adinet.com.uy (8.9.3/8.9.3) with ESMTP id CAA11392 for ; Wed, 21 Jun 2000 02:21:21 -0300 (GMT) Message-ID: <39505126.35E6FFBB@adinet.com.uy> Date: Wed, 21 Jun 2000 02:22:46 -0300 From: Haroldo Stenger Reply-To: hstenger@ieee.org Organization: PRISMA, Servicio y Desarrollo X-Mailer: Mozilla 4.72 [en] (X11; I; Linux 2.2.14 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: Sequences do not obey transactions... References: <39504DD3.6744F245@adinet.com.uy> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/528 Haroldo Stenger wrote: > And I add one of my own: It is not really necessary to have continuity in nearly > all apps. Your question is valid anyhow, but ask yourself: How does Oracle > resolve this? How would I program it myself by hand? And there you'll understand > the issue deeply. How funny it is to quote myself :9 I'd like to add this: When one has to number paper forms (invoices for instance), one must be careful about holes in sequences. What I do, is to have two sequences. One for the user, and one for the system. When the user has confirmed all her data, I'll COPY to another table the data, which NOW doesn't have a chance to cancel. Well, not so sure, but 99% of aborts, are user aborts. So this may help. Note to Bruce (or current FAQ mantainer): Please, add both the answer to the very question, and this addition of my own to the FAQ. I would have loved to find it somewhere, when I didn't know what to do. Regards, Haroldo. -- > ----------------------+------------------------ > Haroldo Stenger | hstenger@ieee.org > Montevideo, Uruguay. | hstenger@adinet.com.uy > ----------------------+------------------------ > Visit UYLUG Web Site: http://www.linux.org.uy > ----------------------------------------------- -- ----------------------+------------------------ Haroldo Stenger | hstenger@ieee.org Montevideo, Uruguay. | hstenger@adinet.com.uy ----------------------+------------------------ Visit UYLUG Web Site: http://www.linux.org.uy -----------------------------------------------