Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A330E9FB4D8 for ; Sat, 24 Feb 2007 19:37:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 40667-01 for ; Sat, 24 Feb 2007 19:37:17 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 430F29FB490 for ; Sat, 24 Feb 2007 19:37:17 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so510210ugf for ; Sat, 24 Feb 2007 15:37:15 -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:mime-version:content-type:content-transfer-encoding:content-disposition; b=FrROzRc8L2Qil+FZiRc21smC5MVSgHlFOhznaSsWf9efqjMgtTl+fLCMQHBKKyUNga+bcbZrJIezAmPh4KeBZNJppuv2lxuL0EKcTjQZRNOMEllkQ+uwoI74A7WcXvLa951pZQKmSJkvrHAjr4ilQbevhIyqCF+pn9Q6WkcwIZU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=KCMmxhFxgYD5xubqUfirTSJkkyTp+qwcrmSS7pLColqnRRb+GfvlnrgT7XtCjlIfMVQBpxVCmfQZbQC85syDNc/7LIsf6e6oxfnuC+hUHHn4xkODnmYiF1sEN+nFSFhpbhAkjQlMsgsgH+t1rQIDt0p0gusUvv94F90uEqzeQoU= Received: by 10.66.244.10 with SMTP id r10mr4173923ugh.1172360235689; Sat, 24 Feb 2007 15:37:15 -0800 (PST) Received: by 10.67.94.13 with HTTP; Sat, 24 Feb 2007 15:37:15 -0800 (PST) Message-ID: <55c095e90702241537q50704797g36665b6c0b2dd81b@mail.gmail.com> Date: Sat, 24 Feb 2007 20:37:15 -0300 From: "Ezequias Rodrigues da Rocha" To: Pgadmin-Support , pgsql-sql@postgresql.org Subject: Change a field to sequence (serial) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/126 X-Sequence-Number: 6700 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/