X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 196A65284D for ; Tue, 21 Jun 2005 07:08:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18473-05 for ; Tue, 21 Jun 2005 10:07:56 +0000 (GMT) Received: from mx2.aiidatapro.com (yanko.aiidatapro.com [195.47.193.12]) by svr1.postgresql.org (Postfix) with SMTP id 82F785280D for ; Tue, 21 Jun 2005 07:07:53 -0300 (ADT) Received: (qmail 12643 invoked by uid 1001); 21 Jun 2005 13:08:19 +0300 Received: from 192.168.1.10 by gruhcho (envelope-from , uid 64011) with qmail-scanner-1.25st (clamdscan: 0.84rc2/849. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(192.168.1.10):. Processed in 0.049185 secs); 21 Jun 2005 10:08:19 -0000 X-Qmail-Scanner-Mail-From: kr@aiidatapro.com via gruhcho X-Qmail-Scanner: 1.25st (Clear:RC:1(192.168.1.10):. Processed in 0.049185 secs Process 12635) Received: from unknown (HELO mailserver.aiidatapro.com) (192.168.1.10) by gruhcho.aiidatapro.com with SMTP; 21 Jun 2005 13:08:18 +0300 Received: (qmail 10361 invoked from network); 21 Jun 2005 10:07:51 -0000 Received: from unknown (HELO adpdev1.aiidatapro.net) (192.168.1.35) by zmei.aiidatapro.com with SMTP; 21 Jun 2005 10:07:51 -0000 From: Krasimir Dimitrov Reply-To: Krasimir Dimitrov Organization: AiiDatapro LTD To: Kenneth Gonsalves Subject: Re: customising serial type Date: Tue, 21 Jun 2005 13:07:57 +0300 User-Agent: KMail/1.7.2 References: <200506211531.28871.lawgon@thenilgiris.com> In-Reply-To: <200506211531.28871.lawgon@thenilgiris.com> Cc: PostgreSQL SQL MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200506211307.57723.kr@aiidatapro.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.262 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/262 X-Sequence-Number: 21863 On Tuesday 21 June 2005 13:01, you wrote: > hi, > in a table with a serial datatype, how do i get the sequence to start > at a specific number like 100000? ALTER SEQUENCE sequence_name RESTART WITH 100000; -- ________________________________________________________ Krasimir Dimitrov IT Department AII Data Processing Ltd., 16 Ivan Vazov Str, Sofia 1000, Bulgaria Phone: +359 2 9376 352 E-mail: kr@aiidatapro.com http://www.see-news.com