Received: from qmail.crp.dnsalias.com (r-bo043-1-62.tin.it [213.45.32.62]) by postgresql.org (Postfix) with SMTP id 78D9F4762A1 for ; Wed, 17 Apr 2002 08:44:24 -0400 (EDT) Received: (qmail 27926 invoked by uid 64014); 17 Apr 2002 12:44:04 -0000 Received: from m.beccati@crpsoftware.it by web1 with qmail-scanner-1.03 (sweep: 2.7/3.51. . Clean. Processed in 2.415601 secs); 17 apr 2002 12:44:04 -0000 Received: from unknown (HELO smtp.crp) (10.1.3.151) by 10.1.3.1 with SMTP; 17 Apr 2002 12:44:01 -0000 Received: (qmail 14626 invoked from network); 17 Apr 2002 12:42:29 -0000 Received: from neptune.crp (HELO neptune) (10.1.1.8) by sentinel.crp with SMTP; 17 Apr 2002 12:42:29 -0000 From: "Matteo Beccati" To: Subject: How to reset sequences on pre-7.1 Date: Wed, 17 Apr 2002 14:44:01 +0200 Message-ID: <2780D698C269CB4EB303715BA48B6A104D35@sole.CRP> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200204/207 X-Sequence-Number: 7471 Hi, I usually use a: SELECT setval('seq_name', NULL); to reset sequences, so the next time it's called it returns '1'. This works in all Pg releases I've ever tested but 7.0. On an hosted space that still has a 7.0 release candidate, this query fails, telling me that I cannot use a 0 value. Anybody knows how to reset sequences in this case? Regards -- Matteo Beccati http://www.phpadsnew.com http://phppgads.sourceforge.net