Received: from bering.webline.dk (83.adsl0.kh.worldonline.dk [213.237.10.83]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBLA98694750 for ; Thu, 21 Dec 2000 05:09:08 -0500 (EST) (envelope-from kar@webline.dk) Received: from localhost (localhost [[UNIX: localhost]]) by bering.webline.dk (8.10.2/8.10.2/SuSE Linux 8.10.0-0.3) id eBLAA1X25189 for pgsql-sql@postgresql.org; Thu, 21 Dec 2000 11:10:01 +0100 From: Kaare Rasmussen Date: Thu, 21 Dec 2000 11:10:00 +0100 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" To: PostgreSQL-SQL Subject: Invoice number MIME-Version: 1.0 Message-Id: <00122111100003.25042@bering> Content-Transfer-Encoding: 8bit X-Archive-Number: 200012/245 X-Sequence-Number: 582 Hi My, my. It works. How many times have I tried this mailing list with no success :-( I'm wondering how people creates guaranteed sequential numbers - in my case for invoice numbers. - Sequences are not rollback'able. - It seems overkill to have a table just for this. - What else? tia