X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 36B66D1B4BC for ; Fri, 19 Mar 2004 14:38:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18570-07 for ; Fri, 19 Mar 2004 10:38:37 -0400 (AST) Received: from snowwhite.lulu.com (stymie.lulu.com [66.193.5.50]) by svr1.postgresql.org (Postfix) with ESMTP id 217FCD1E966 for ; Fri, 19 Mar 2004 10:38:33 -0400 (AST) Received: from lulu.com (meatwad.rdu.lulu.com [10.0.0.32]) (authenticated) by snowwhite.lulu.com (8.11.6/8.11.6) with ESMTP id i2JEeFE00687 for ; Fri, 19 Mar 2004 09:40:15 -0500 Message-ID: <405B05EB.90001@lulu.com> Date: Fri, 19 Mar 2004 09:38:35 -0500 From: Bill Montgomery User-Agent: Mozilla Thunderbird 0.5 (X11/20040210) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: unimplemented functions References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/256 X-Sequence-Number: 12825 chris@zenmgt.com wrote: > I'm new to postgres and pgadmin3 (on Windows XP). > > I've just tried to make a change to a table using pgAdmin3 (1.0.2) and > I get:- > > --------------------------- > pgAdmin III > --------------------------- > An error has occured: > > ERROR: adding columns with defaults is not implemented > HINT: Add the column, then use ALTER TABLE SET DEFAULT. > > --------------------------- > OK > --------------------------- > > When will this be fixed? Is this the right forum for discussing > unimplemented fuctions? Is there somewhere or someone specific to > point is out with? Chris, This isn't a pgadmin bug--it is a limitation of Postgres. You can't add a column to a table *and* set a default value for it all in one statement. Try the hint that is given: add the column, then alter the column to set the default value. You can read the details of using the ALTER command in the Postgres online documentation. Regards, Bill Montgomery