X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4BC0B9DC80D for ; Wed, 15 Feb 2006 20:54:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71504-01 for ; Wed, 15 Feb 2006 20:54:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [151.155.5.143]) by postgresql.org (Postfix) with ESMTP id 93EE69DC800 for ; Wed, 15 Feb 2006 20:54:08 -0400 (AST) Received: from [172.16.1.101] grzm [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.6 $ on Linux; Wed, 15 Feb 2006 17:54:07 -0700 In-Reply-To: <1113783300.20060215191156@isb.com.pl> References: <1113783300.20060215191156@isb.com.pl> Mime-Version: 1.0 (Apple Message framework v746.2) X-Priority: 3 (Normal) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <7F00B433-6977-4340-841A-2084DD9736D4@myrealbox.com> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: alter table Date: Thu, 16 Feb 2006 09:54:10 +0900 To: Maciej Piekielniak X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.093 required=5 tests=[AWL=-0.239, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.093 X-Spam-Level: * X-Archive-Number: 200602/196 X-Sequence-Number: 24206 On Feb 16, 2006, at 3:11 , Maciej Piekielniak wrote: > How can i modify few fields with alter? I think you need to alter columns one at a time. If you need them to go into effect at the same time, you can wrap the multiple ALTER TABLE statements in a transaction. For example, begin; ALTER TABLE fv_wystawione ALTER id_fv SET DEFAULT nextval ('id_fv_seq'::text); ALTER TABLE fv_wystawione ALTER imie SET DEFAULT ''; commit; Michael Glaesemann grzm myrealbox com