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 693D69DC884 for ; Wed, 15 Feb 2006 14:12:02 -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 83421-07 for ; Wed, 15 Feb 2006 14:12:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from isb.com.pl (isb.com.pl [212.160.150.140]) by postgresql.org (Postfix) with ESMTP id 2F2899DC821 for ; Wed, 15 Feb 2006 14:12:00 -0400 (AST) Received: from 192.168.0.17 (sembrz [192.168.1.50]) by isb.com.pl (Postfix) with ESMTP id F2F8D57842 for ; Wed, 15 Feb 2006 19:09:15 +0100 (CET) Date: Wed, 15 Feb 2006 19:11:56 +0100 From: Maciej Piekielniak X-Mailer: The Bat! (v1.62r) Reply-To: Maciej Piekielniak X-Priority: 3 (Normal) Message-ID: <1113783300.20060215191156@isb.com.pl> To: pgsql-sql@postgresql.org Subject: alter table MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/174 X-Sequence-Number: 24184 Hello , How can i modify few fields with alter? ALTER TABLE fv_wystawione ALTER id_fv SET DEFAULT nextval('id_fv_seq'::text), ALTER imie SET DEFAULT ''; Syntax error in last line. -- Best regards, Maciej mailto:piechcio@isb.com.pl