Received: from falcon.prod.itd.earthlink.net (falcon.mail.pas.earthlink.net [207.217.120.74]) by postgresql.org (Postfix) with ESMTP id 6EDB4475451 for ; Fri, 26 Apr 2002 12:19:17 -0400 (EDT) Received: from 1cust208.tnt2.richmond.in.da.uu.net ([63.26.248.208] helo=nick) by falcon.prod.itd.earthlink.net with smtp (Exim 3.33 #2) id 1718RH-0004Vn-00; Fri, 26 Apr 2002 09:19:16 -0700 Reply-To: From: "Nick Fankhauser" To: "Tom Lane" Cc: "PGSQL-SQL" Subject: Re: How do I create unique IDs for an existing set of records Date: Fri, 26 Apr 2002 11:17:51 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 In-Reply-To: <26777.1019837679@sss.pgh.pa.us> Importance: Normal X-Archive-Number: 200204/328 X-Sequence-Number: 7592 > You are overthinking the problem; this should work: > > update test set new_pk = nextval('test_new_pk_seq'); Thanks Tom! It did indeed work. -Nick