Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5DA1A9FB471 for ; Sun, 25 Feb 2007 02:07:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 04959-07 for ; Sun, 25 Feb 2007 02:07:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.237]) by postgresql.org (Postfix) with ESMTP id B093C9FB46E for ; Sun, 25 Feb 2007 02:07:36 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so1016610nzh for ; Sat, 24 Feb 2007 22:07:35 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=CxTuWYk2QQo2aP7BiwQYkJ5TkTCD0m2LDa21C3jz7ZIjXKhblp0UvIkUJSEiRksuWoSAI0av7t+GgKwfc7i9/JqtbX1I1tuoE7NXXuQSfAiSGPfQ1IsXJ/oxULx9QioQKFaPNTtO2DSmQDtb4Y3Roq8w28TKF1+ifIKoPOgveYs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=l2RFHJCcKv+ArY4ZQg1QbNyF7E4xT3foI74X7r8ohWzU9aiLCsLyt/engKCt52RhYQhKpO6KO7PJQyjgnJiRDxee/BugBu7PlRxcgI5SDVRnFhcGGx1MWVzgwhZQrc3Ptmpmuy9sVdA4yJk3yUrVgOjqTJGqGgh+TZSu3i3XVvI= Received: by 10.115.111.1 with SMTP id o1mr904736wam.1172383655545; Sat, 24 Feb 2007 22:07:35 -0800 (PST) Received: by 10.114.169.12 with HTTP; Sat, 24 Feb 2007 22:07:35 -0800 (PST) Message-ID: Date: Sun, 25 Feb 2007 01:07:35 -0500 From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" To: Pgadmin-Support , pgsql-sql@postgresql.org Subject: Re: [SQL] Change a field to sequence (serial) In-Reply-To: <55c095e90702241537q50704797g36665b6c0b2dd81b@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <55c095e90702241537q50704797g36665b6c0b2dd81b@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/131 X-Sequence-Number: 6705 On 2/24/07, Ezequias Rodrigues da Rocha wrote: > Hi lists, > > Is there possible to change a bigint field (primary key) to a serial ? > If yes how it is possible ? > > I was trying to do that but the pgadmin don't enable the change to sequence. > > What is the problem my friends ? > > Regards > Ezequias > http://ezequiasrocha.blogspot.com/ See: http://www.postgresql.org/docs/8.2/static/datatype-numeric.html#DATATYPE-SERIAL http://www.postgresql.org/docs/8.2/static/functions-sequence.html